In your code - you are not specifying RECOVERY which tells SQL Server to finish the backup and recover the database.

From the GUI - you need to select the option...

SQLdba-473999 (3/10/2011)

---

Thank you for your response. Since this will occur after hours I believe the DBs in high performance mode should be fine - I'll just watch the log...

Most likely the issue is with the data - but, there is at least one bug that might apply here:

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

Validate the version you are running, and if it is not...

I think it really depends on how large your transaction logs are now, and whether or not you have enough room in them to handle the increased usage.

For example, I...

jligda 35032 (3/7/2011)

---

I just read that SQL 2005 Standard only supports 4 CPUs!

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

We have two quadcore Xeon e5410 @ 2.33GHz. What happens when you try and run standard 2005...

With this server configuration, I have to assume you either have multiple instances - or you have many more databases in that instance that just this one database.

If this is...

Right-click on the database you want to check and run the Schema Changes History report. Note, this report uses the default trace and will only go back as far...

I don't have any idea about your system - or the indexes that you are rebuilding and how much space is required.

You need to identify how large the indexes are...

Yes - and that is the problem...it might break the log chain, but no way to be sure. So, to be safe - I would not recommend running transaction...

No, NO, NO...

Yes, the transaction log file filled up during that...

There is a very small possibility that you could be in the middle of a transaction log backup - and the drive becomes unavailable just at the right time to...

I would not stop performing transaction log backups and rely solely on database snapshots or even SAN snapshots. First, you cannot restore to a point in time from a...

Not necessarily - update statistics does not block user processes because it is run in read uncommitted transation isolation.

If you don't have a lot of memory and/or you have a...

There is a new option that will help - it is the Auto Update Stats Asynchronous. Turn that on and if a request to auto update stats occurs, it...

Since you are on shared storage, performance issues are going to harder to track down because you won't know who else is actually hitting those spindles.

If your SAN guys are...