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.
| Author |
Topic |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2009-03-26 : 14:39:55
|
| We migrated from standalone servers running SQL2000 to VMWare & SAN, running SQL 2005. Our Large DB used to take 16 hours to backup, and is now taking 3 days !!!! Is there anything SQL related that could possibly affect the time to run a backup ?? I've tried pointing the backup location to the SAN and to a standalone server on the same rack & both are 3 days. The backup starts out fast at about 1 gig per minute but then just gets slower & slower. I'm assuming the problem is some configuration in VMWare, or the SAN or NICs ..... but if there's anything within SQL that I can look I'd like suggestions.TIA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-03-26 : 14:46:21
|
| For a large database, you shouldn't be using the native backup solution. You should really look into Quest's Litespeed product or even Red Gate's SQL Backup product.I can't think of anything in SQL Server to look at, but you should know that Microsoft will not support SQL Server on VMWare so be careful. We do have tons of SQL Servers on VMWare though, so if you call PSS just make sure to hide the fact that it's a VM.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2009-03-26 : 14:55:28
|
| Thanks, I should have mentioned that we are using Redgate for backups. Microsoft does now support some versions of VMWare, but I don't know the specifics.FWIW, The database is about 850 Gig. Previously I was writing to a Buffalo terraserver attached drive, and then the standalone server a few times. Backup times were comparable and they only had 1 or 2 drives. The SAN has 16 drives but is shared by various other servers in different LUNs. My smaller databases ( less than 100Gig) seem to backup in a normal amount of time. It's just the big one that bogs down after it's written about 200 gig. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2009-03-26 : 16:03:23
|
| Good thinking, but yes, we've done that. We're omitting .MDF, .LDF, .NDF, .SQB, .BAK extensions. (I'll double check with the Network Admin) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Slow Backup after Migrating to 2005