May 7, 2003 at 3:16 am
The development server is crashed and we need a new copy of the database of the client.
The database at the client is SQL Server 7.0 and I want to backup (of copy) all the tables and stored procedures. It's serveral Gb of data is it possible to devide it on serveral cd's ?
And can I import that easely in SQL server 2000 ?
Thnx
Wimel
May 7, 2003 at 4:32 am
You can create multiple backup files and restore from those files (see BOL for BACKUP DATABASE, Note: I have seen issues with multiple backup files to DISK where the sizes don't look right and am not sure how it calcs them but a single 12MB backup ends up as 4 4MB files when I do 4 DISK pieces may be due to some kind of simple parity for the data itself as 5 DISK items make 5 3 MB files, so I would assume to get to the size you need per disk try dividing the DB space by size of CD space = 1 extra disk) however it might be worth your time to explore SQL-Zip http://www.sqlzip.com/ or SQLLitespeed http://www.sqllitespeed.com/ as backup solutions since both compress the backup as it is done.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply