Please check if these scripts help.

http://www.mssqltips.com/tip.asp?tip=1584

http://www.sqlservercentral.com/scripts/Backup+and+Recovery/63071/[/url]

Please check if any of the workarounds listed here are useful.

Since you have not mentioned SQL Server build details, please check if these hotfixes help.

http://support.microsoft.com/kb/896980

http://support.microsoft.com/kb/832674

If your regular...

@sqldba_icon,

You can also query the SQLBinRoot key in the registry. It is located in the following key for SQL Server 2008 default instance. You may navigate to the Setup key...

You need not change any settings on the instance. The Service Pack installer will take care of stopping and starting the instance.

Please run DBCC LOGINFO against that database and check if the status for any VLFs is 2. If yes, then issuing transaction log backup multiple times until all the VLFs'...

You can make use of the steps mentioned in these articles.

http://www.mssqltips.com/tip.asp?tip=1764

http://support.microsoft.com/kb/958734

Satish-219904 (1/6/2011)

---

I will look into that. On a side note, do you recommend us to go with Database Mirroring (Async) Vs. Log Shipping. We have no requirement for automatic failover....

You can make use of the -W switch in the sqlcmd utility to remove trailing spaces.

In the first question I assume is about which account to set as Database Owner. You can set any account or "sa" as DBO.

For the second question, do you see...

The SQL Server Agent process is crashing. Please go through the SQL Server Agent log (SQLAGENT.out) to find out what is causing this issue.

If you can afford down time you can bring down the SQL Server instance and then use a tool like ROBOCOPY to copy the files to a different location.

Rebuilding the selective indexes would surely bring down the size of the Transaction Log backups.

After rebuilding the index if the fragmentation level increases drastically the very next day, then it might be a good idea to rebuild it on a daily basis. Otherwise rebuilding...