backup using snapshot on SQL server

[daproud]

Is anyone using sql server 2k virtual device interface for a quick backup and restore? I am trying to find a way to do a quick restore daily on a database that is about 40 gb in size so that it can be used to run reports on. right now it takes four to five hours to restore. If someone can point me to a link or share thier experience that would be great. I have been looking on-line and have come up with a little info from EMC and Qinetix.
Thanks,
Dave

 

[Catadmin]

Dave,

Have you tried optimizing it first? You know, using DBCC ShrinkDatabase and defragmenting the pages? That might bring down the size a little to a more manageable level.

Also, a new third product I just discovered is called "SQL LiteSpeed". It has a special compression ability specifically designed for SQL Backups. We're just now starting to implement it in our test environment, so I haven't had a chance to see how good it works, but I've been told it can take a 40 minute restore down to less than 5 minutes.

Here's the Link:

http://www.quest.com/litespeed_for_sql_server/index.asp

Hope that helps.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.