Backup a large database

1) What is the best way to backup a large database >100GB.
Backed up files should be able to restore on a DR server,
I can not use file group backup because it will only allow
me to restore it back to original server.
If use dump database method will give me a 100GB single
file.
2) How can I upgrade a database from SQL 7.0 with a single
30 GB data file in primary group (only one file group ) to
SQL 2000 with multiple file groups, I have tried to create
a database with two file groups in SQL 2000 then restore
the backup taken from SQL 7.0 , but this will restore the
single file setting from SQL 7.0 and over written the
database setting in SQL 2000 .Ji
Have you tried to compress you backup file (like .ZIP or .RAR) ?
"Ji" <zhijun.ji@.rbc.com> wrote in message
news:038c01c354c5$05752680$a301280a@.phx.gbl...
> 1) What is the best way to backup a large database >100GB.
> Backed up files should be able to restore on a DR server,
> I can not use file group backup because it will only allow
> me to restore it back to original server.
> If use dump database method will give me a 100GB single
> file.
> 2) How can I upgrade a database from SQL 7.0 with a single
> 30 GB data file in primary group (only one file group ) to
> SQL 2000 with multiple file groups, I have tried to create
> a database with two file groups in SQL 2000 then restore
> the backup taken from SQL 7.0 , but this will restore the
> single file setting from SQL 7.0 and over written the
> database setting in SQL 2000 .
>|||Ji,
> 1) What is the best way to backup a large database >100GB.
> Backed up files should be able to restore on a DR server,
> I can not use file group backup because it will only allow
> me to restore it back to original server.
> If use dump database method will give me a 100GB single
> file.
Get yourself one or more large tape units - DLT or Super AIT for instance.
Then backup straight to tape.
> 2) How can I upgrade a database from SQL 7.0 with a single
> 30 GB data file in primary group (only one file group ) to
> SQL 2000 with multiple file groups, I have tried to create
> a database with two file groups in SQL 2000 then restore
> the backup taken from SQL 7.0 , but this will restore the
> single file setting from SQL 7.0 and over written the
> database setting in SQL 2000 .
Use the database upgrade wizard that came with SQL 2000.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq