Gurus,
Running SQL Server 2005 SP2.    I understand that those who run their
databases in SIMPLE recovery mode don't need to recover all there data to a
point in time - everything that was there at the time of the last full

restoring backups.
Suppose my database with FULL recovery model crashed at 2PM, and I have the
following:
a) full backup from midnight

I was able to script my profiler trace (see the script below) but when
I ran it from Query Analyzer it quickly gave me a Trace Number.
Does it mean that the trace is not running? and if it is how can I see
it?

Is there a way to restore a database backup without knowing the timestamp on
it ?. Renaming the .BAK file is not an option. I want to automate this
restore for everyday AM. Thanks................
SQL Server 2000 SP4 - Windows 2000

Full backup at 02.00 to a single file using overwrite.
Differential backup at 07.00 to single file user overwrite.
Differential backup at 19.00 to the file above using overwrite.
If restoring the db i understand full backup should be executed then the

Don't know if this is the right forum (ADO.NET SQL Question), but here
goes...
I am playing with the standard "Orders" (a parent table) and
"Order_Details" (a child table) tables found in Northwind, and

I am using IndexReorg proc from Ola Hallengren (a Great Uility if you haven't
run into it yet) during Weekly maintenance to reorg the indexes on our prod
DB.
After running the utility at roughly 3am this weekend, we immediately

I am trying to write a query that will display the average
fragmentation of the indexes in all my databases but I have fallen at
the first hurdle.
I have started by writing the query to bring back all of the

I want to do a performance audit on a dedicated SQL Server machine over a 24
hour period.  So I’m going to collect a bunch of System Monitor performance
counters to do this audit.  I only want to do this System Monitor event once,
and don’t want to miss any counters.   So I’m ...

We've purchased SAN and we are going to place all files related to SQL.
Can any one please let me know what will happen if we use SAN.
What is the main purpose if we place all mdf and ldf files.
It'll increase the performace of the application while accessing please

I am testing a new monitoring tool in our environment and one of the
parameters to test is databases going suspect.
Forcing a database to go suspect has turned out to be more difficult than I
thought.

I'm converting a SS6.5 database to SS2005.  Is it possible to query
the 6.5 database using any of the 2005 tools, or is my only
alternative to use iSQL for 6.5?

has anyone heard when Microsoft is going to release Microsoft® SQL
Server® 2008 Express with Advanced Services _with Service Pack 1_ and
the Download for Books Online 2008 _March_ 2009
(http://msdn.microsoft.com/en-us/library/ms166018.aspx)?

Good day
I would like to store data daily on 30min intervals.I have a DateLookup
tables that contains a Datekey column as INT and the Date column as DATETIME..
example 20090430 , 2009/04/30 12:00:00 AM

We are facing  application slowness daily morning 11 am.Even saturday and
sunday also.
for backend we are using sql server 2005  running on win 2003.
i have traced from all sides like i've run the profilers and every month