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 2005 Forums
 SQL Server Administration (2005)
 Database is in restore mode

Author  Topic 

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-02-04 : 12:35:05
Ok here is whats going on Transaction logs are being backed up. in the options area says Under Transaction Log
BACK UP THE TAIL OF THE LOG, AND LEAVE THE DATABASE IN THE RESTORING STATE.

How do you stop that???

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-02-04 : 14:10:42
nevermind its all good now
Go to Top of Page

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-02-05 : 11:11:52
I have a question about the Tail Log being backed up first before backing up. I have a database thats in Full Recovery mode and I want to backup the Tail log first, the thing is when I did that yesterday it took a long time like over 45mins. Is that normal, see the database is 2714.13 MB. Is that normal or should I be alarmed??
Go to Top of Page
   

- Advertisement -