Are you using FULL RECOVERY and back-up the log frequently?

Open 'Management' in Management Studio, select 'Maintenance Plans' and create a new maintenance plan using Maintenance Plan Wizard.

Please close topic.

BACKUP DATABASE [name] TO DISK=N'[path+filename]' WITH NOINIT

and make sure the extension of the back-up file is .BAK

Thanks everybody. Please close topic.

tmc (12/3/2007)

---

They provided the required amount of disk space I needed, but when I asked "How many disks?" and "How many different RAID groups?" made up the allocated space, they...

I used this technique in both 2000 and 2005.

On DB.A run:

BACKUP DATABASE [name database] TO DISK = N'[path and filename.bak]' WITH NOINIT, SKIP

Startup Management Studio on DB.B. Create a new...

You need to make a new back-up to a file. Remove the back-up device in the dialog and select file. Create a new file and back-up to it. Then...

You could try to back-up the database to a file in stead of a device. Create a new database (with required name) on the other server and restore the file...

Thanks everyone. I'll post detailed database information & shrink results as soon as possible.

@ Moderator

Can you please move this thread to the right section (MS SQL Server 2005)? Thnx

In SQL Server 2000 we used the simple recovery model.

Oops, this message should be in administrating SQL Server 2005