So you can restore the database by stopping and starting the server?

Else you need to check for the SPIDs that are blocking the database. Use the master database to restore.

Restore...

WITH NORECOVERY to WITH RECOVERY

For the above can some one explain what is their difference?

As for the last trans log to be restored we specify with recovery ,

why is...

Adding to that, you can restore the database with SQL Server EM:), you can use the TSM backup and restore process. Also there would be few third party tools to...

• This reply was modified 5 years, 8 months ago by  RGP.
• This reply was modified 5 years, 4 months ago by  Dave Convery.

Hi, what is the SP that you are using to restore?

you can move the backup from server 1 to server 2 using a shared folder, or by using the...

Hi, use the master database and run the command sp_who2 to check who is accessing the database that you are trying to restore.

check for the spid here against the database.(blkby...

hmm..you may be right, I actually used this command through VB, however when the users forgot their password we had to reset with a new one! there was no way...

I have tried it on sql 2000.:) and it worked..

Hi,

Yes you are right ServerA has SQL Server. ServerB does not .

Yes want to run a command line on ServerB after ServerA finishes restoring a database.

The load to database...

thanks Gail!! very helpful info!

SELECT ENCRYPT ('Test')-> when this select query is run on a database the value obtained is in an encrypted format.

Hence, if you did mean that you what to enter...

BACKUP LOG WITH TRUNCATE_ONLY

--->Can some one please tell me what does the above statement do. I understand that the log files are backuped up

My questions are...

Hi, before you apply the SP 2 hotfix, please remember that SQL Server service must be restarted.Also restart the computer before the change is applied.

Even I think its better...

Thank you...Let me explain the scenario....I have a batch job that runs on a virtual server..

I have to run the batch automatically, whenever I am asked to do it(that is...

Thanks sp_readerrorlog..worked!

thanks Carl!, we have a batch file that runs in the command prompt, I want to schedule the batch job to run automatically at a specific time, that time would...