I often need to to backup and restore database(SQL Server 2000/2005). Now if database is of size > 1 GB restoration process is real time consuming.
Is there any way using which i can truncate the logs or reduce the database size? Thanks all,
Asked
Active
Viewed 242 times
3
-
5For the record, 1gb is a pretty small database. – keithwarren7 Jan 26 '10 at 13:23
-
define 'real time consuming' 30 seconds? 1 minute? 10 minutes? – Nick Kavadias Jan 27 '10 at 06:35
3 Answers
2
What exactly do you mean by "time-consuming"?
Restoring a 10 GB database should only take a couple of minutes. So no big deal at all. If you need to do this on a regular basis, create a job for that and schedule it to run before you get into the office.
Any action would have to take place before you backup the database, but I wouldn't recommend shrinking the files if you are going to restore the database on a production system.
Frank Kalis
- 161
- 1
2
In order to speed up your backup and restore process you may want to consider using third party backup technology such as.
On a side note, modyfying the size of your Transaction Log will not influence the volume of data that is being backed up/restored.
John Sansom
- 643
- 3
- 7
0
- Are you using instant file initialization?
- Is 1 GB backup size, MDF size or LDF size?
1 GB is quite small, really...
gbn
- 6,079
- 1
- 18
- 21