standby sql server 2005 significance and restore to active

In sql server 2005 what is the significance of the database in standby mode and how to make it active
Greens8301Asked:
Who is Participating?
 
jorge_torizConnect With a Mentor Research & Development ManagerCommented:
RESTORE LOG YourDBName
FROM DISK = 'C:\YourLast_LogBackup_File.trn'
WITH RECOVERY
0
 
bcsqlConnect With a Mentor Commented:
Standby mode when restoring a database lest you apply trans log backups to the databases and leaves the database in a read only mode. Useful in logshipping when you want to read the database you are logshipping to say for reporting. Use the with recovery option when restoring a database when all trans logs have been applied and you want the database out of readonly mode.

http://msdn.microsoft.com/en-us/library/ms188223(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx

0
 
jorge_torizResearch & Development ManagerCommented:
The stand by mode put your database in a read-only mode, storing all the uncommited transactions in your stand by file... if you want to make it active, you can take your last log backup and restore it using WITH RECOVERY

This is commonly used in log shipping
0
 
Greens8301Author Commented:
Is there a T-SQL command to make it active WITH RECOVERY option

Thanks
0
 
Greens8301Author Commented:
Thanks got the quick reponse
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.