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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Slow Back UP Issue

Author  Topic 

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2010-04-27 : 03:04:39
Hi Friends

i have a back up issue.
Database : SQL Server express 2006
I took back and obtained following backuprate.
Database Metrics :

Db1.MDF size 195560
Db1.LDF size 4464
PageProcessedMDF 184160
PageProcessedLDF 46

TimeTaken(S) 1355.594
DataRate(MB/Sec) 1.113

Availbale RAM 4 GB

Also i am doing back in separate drive.
Similar back took place in 515 seconds at some other place.
Assist me the possible solution to mininize back time.


Thans and Regards

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-27 : 12:21:45
Get faster disks and/or stripe the backup across multiple files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -