How can I backup a large db?
Posted on 2003-10-24
I need to do a quick and dirty backup of a database 130 GB in size...
What I plan is:
alter database BigDB
set single_user with rollback immediate
copy the db files to another server....400 GB free (RAID-5)
then, on the original server:
sp_attach_db 'BigDB','d:\Program Files\Microsoft SQL Server\MSSQL\Data\BigDB_Data.mdf'
restore database 'BigDB' with recovery
Will this work?
I have most of the weekend to do it.
Is there minimal risk of loss to my data?
Is there a way to do this while the db is online?
Any other suggestions? (BTW, I dont have a tape drive large enough...)