Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring Transaction Logs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-16 : 08:03:20
Reza writes "I am trying to Restoring Transaction Logs on the SQL Server 2000, however It gave me error# 42000, that your database is busy. How will I be bake to restore the Transaction Logs on the SQL Server. Please let me know.


Thanks"

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-16 : 08:28:28
How are you doing this?

====================================================
Regards,
Sean Roussy

Thank you, drive through
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-08-17 : 07:43:36
Set the oven to 350 ...

You can't do restores if there are connections to the database. You need to remove all the users before beginning a restore.

Jay White
Go to Top of Page
   

- Advertisement -