it won't help this time I know, but I always keep flat files copies of the system databases (I take a copy at each upgrade), then these can just be...

do you have another instance of SQL at the same version? You could restore the master backup as a user database (change its name and physical file names on the...

If you have logshipping set up those are the ONLY log backups you should have. It fully takes care of your transaction logs

the link i posted should answer your questions but you dont need to remove mirroring to set up logshipping.

well looks like I finally learned to type faster than you!

😉

A mirrored database can also be log shipped, so you have that option open to you for your replication to the DR site.

http://msdn.microsoft.com/en-us/library/ms187016(v=sql.100).aspx

vikingDBA (11/16/2012)

---

See the following url for an Instance Security Audit script I wrote. It prints in columnar format, and you can change one variable to make it print the...

I would clarify Perrys tail log backup script, it depends why you are failing over. If you are failing over because the primary is damaged but the log file is...

on the primary manually take a last log backup with norecovery, apply that to the secondary with recovery to bring it online. Then when you want to switch back backup...

have you looked at the link i posted?

You asked for a script...

try this[/url], exactly what you want.

read the discussion afterwards as well

thanks for posting this, most useful, especially detailing the steps.

I hit this error (on a server restart, not an install) and added the ServicesPipeTimeout DWORD, in my case SSRS then...

Yes, there is a very large translog file (2.1GB) in the TRN backup folder, followed by others no larger than 35MB. So I shouldn't see any more of these very...

run dbcc loginfo(yourdb) to see how many vlfs you have and where the last active one is (status = 2)

you also possibly have quite large vlfs, a log file needs...