| Author |
Topic |
|
lordzoster
Starting Member
29 Posts |
 Posted - 2009-01-13 : 12:31:37
|
| halloi'm running a MSSQL2000 on a W2000 std server, upon a Dual Xeon ML530 with 2GB Ram and RAID5 data hdd.In the same istance of MSSQL there are some dbs that serves 50 users, some bigger (1GB) some very small.One of these, a 300MB one, has very long backup times (a full backup can last 1h, a differential even 50'): it implements a full recovery model.The backups are performed in the same way for all the dbs.What could it be? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 12:59:54
|
| Are you talking about database in MB or GB? |
 |
|
|
lordzoster
Starting Member
29 Posts |
Posted - 2009-01-13 : 13:09:58
|
| MB, MegaBytes |
|
|
|
lordzoster
Starting Member
29 Posts |
Posted - 2009-01-13 : 13:17:08
|
| I launched a manual backup into a device on file: taking a look at the "process informations" node in the EM, the backup process is locked by another process that is locked by a BACKUP LOG, which is appending transaction LOG backups into a 10GB file... considering that the DB is 300MB only, this COULD be a hint. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lordzoster
Starting Member
29 Posts |
Posted - 2009-01-14 : 02:13:20
|
| Hi Tara,I backup logs every 5 mins, we have quite a low number of transactions but are in a highly critical environment (medical) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-14 : 03:25:28
|
Increase size to 15 minutes so that full backup can take place without disturbance.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-01-14 : 07:51:17
|
| Consider putting the Logs into their own seperate files.....Have a look at some of TKizers scripts for backup & restore. They are very useful, very flexible and very comprehensive. |
|
|
|
lordzoster
Starting Member
29 Posts |
Posted - 2009-01-14 : 09:15:01
|
| ok the problem was the log destination file size (and a backup system poorly organized): now i setted a device for each weekday, anda single backup log now takes about 6 seconds. All backups (full, differential, logs) are written in that device, that is overwrited after a week.I'll take again into consideration using a separate log backup device, but i shall going deep into the matter.Anyway thanks for you hints. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Long time to backup a 285MB db