October 1, 2014 at 3:03 pm
We are running SQL Server 2005 for this particular database. The data file (.mdf) is about 60 GBs in size with only one filegroup. We need to copy the database to a vendor's ftp site. I am not sure if we can copy the .mdf file or a database backup file. (I need to determine the backup file size.) I have not spoken to the vendor. I am just doing some research. I am the newbie here.
What are some options to reduce the size of and/or copy this huge file to the vendor's ftp site? How may I determined if the database is compressed (or not) in SQL Server 2005?
Thanks, Kevin
October 3, 2014 at 4:36 am
Hi Kevin,
Compression was introduced with SQL 2008 so I'm pretty sure your database isn't compressed.
I think your best course of action is to take a backup and then compress the backup file with WinZip/7Zip/WinRAR.
Cheers
Gaz
October 3, 2014 at 11:46 am
I agree with Gaz.
The only other option might be to restore the database on another server and then shrink the database file.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply