Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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,

share|improve this question

migrated from Jan 27 '10 at 6:09

This question came from our site for professional and enthusiast programmers.

For 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 6:35
up vote 2 down vote accepted

In order to speed up your backup and restore process you may want to consider using third party backup technology such as.

Quest Litespeed

On a side note, modyfying the size of your Transaction Log will not influence the volume of data that is being backed up/restored.

share|improve this answer

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.

share|improve this answer

1 GB is quite small, really...

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.