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)
 Make a Backup of a Standby Database

Author  Topic 

jhnegrao
Yak Posting Veteran

81 Posts

Posted - 2009-04-01 : 16:53:44
Hello, People!
Good Afternoon!

I have a Standby Server where the Database state is ReadOnly. (Standby mode). I would like to make a Backup of this Database, but I cannot make it online.

Anybody knows how can I do this?

I know that, if I shutdown the SQL Server INstance, I can copy the Datafiles and LogFIles directly from the File System, but I would like to use T-SQL to do it.

Thanks for All
   

- Advertisement -