I agree with Sanket that 7th step is not required.

1) Trace flag is used to detach system databases like model,msdb

2) Trace flag 3608 prevents SQL Server from recovering any database...

Thanks Gail for sharing the info.

Budget is not much so customer dont want to go for clustering...

The goals to achieve are -

1) secondary server (standby) should be always in...

Yes,I do agree with Adi.Atleast I would not recommend the autogrowth option in % for log file.

Max memory supported by SQL server 2000 personal edition on any O.S. is 2 GB

If you want to count the successful logins happend at particular time on your SQL Server the other way is to

1) extaract the sql server errorlog by filtering it...

Experts....Just to remind :-

Instant file initialization is available only on Microsoft Windows XP Professional or Windows Server 2003...

On database server I would suggest you to take a snapshot of SQL Server registry values containing IP address of the server and verify these values after completion of...

Personally I wud prefer being a production DBA but you should be ready to ->

1) work under pressure

2) should be having a depth knowledge on Database structure and

3) ready to...

This may give more clear picture =>

http://www.kodyaz.com/articles/alter-single-user-multi-user-mode.aspx

There is a possibility that you may get dirty reads(uncommited rows) if you use a nolock hint.

Nice Script

Cheers !

You can try Excel's "Get External data" feature to retrive the data into excel sheet.

1) Open an excel sheet

2) Go to "Data" menu

3) Go to "Import External data" menu

4) Click...

Hi Neha,

sqlcmd is the new enhancement over older versions like isql & osql

It has some nice features,see the below link for more details =>

http://www.databasejournal.com/features/mssql/article.php/3491006

Hope it helps !

If you are talking about the user name by which sql service is starting then you can check the same from services.msc

You can check the same from services.msc too..