Backup of Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Backup of Database

Author

Topic

damini_dd
Starting Member

2 Posts

Posted - 2006-06-22 : 06:08:17

Hi All,

I am new to the SQL Server. But the place where I work I've to manage my database of SQL server specially for backups. I don't know how to take backup and what if I want to take back of on CD. Please let me know ASAP.

Thanks in advance

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-22 : 06:12:53

You can backup to Server's local HD and then copy to CD.

use the BACKUP DATABASE command to do it

damini_dd
Starting Member

2 Posts

Posted - 2006-06-22 : 06:17:13

But the file which i've backed up is of 2 GB so I can't take it to CD. and one more thing when i take backup everyday i select append to existing file so I doubt it is appending data daily. So I want to clarify that as well.

thanks for ur help.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-22 : 06:25:00

you can use any compression software to compress it before copying to CD.

If you need to this as a standard backup procedure, i sugguest you to get a backup software to do the job.

Also refer to this for more info. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Backup

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-06-22 : 06:30:52

quote:
Originally posted by damini_dd

But the file which i've backed up is of 2 GB so I can't take it to CD. and one more thing when i take backup everyday i select append to existing file so I doubt it is appending data daily. So I want to clarify that as well.

thanks for ur help.

Backup and then ZIP to multiple archives of 700 mb sizes.
If possible to use DVD, then do that instead due to 4.7 gig size.

Peter Larsson
Helsingborg, Sweden

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-22 : 09:52:28

is 2 GB the size for the mdf file? If it's more of the log file, truncate the log file then shrink it before backup prior to transfer

--------------------
keeping it simple...

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-06-22 : 13:43:25

DON'T append the backup each day. Setup a maintenance plan on the server to right a different full backup file each day. Zip those files and copy them to CD or tape for backup. If you get a corruption in the file with append, you lose everything. Individual files are the way to go for full backups to be used for archiving and DR purposes.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Kristen
Test

22859 Posts

Posted - 2006-06-24 : 01:45:52

"If it's more of the log file, truncate the log file then shrink it before backup prior to transfer"

Does an unnaturally large [e.g. never backed up the TLog] LDF file cause bigger backups then?

I know it crucifies the restore time, didn't realise it made bigger BAKs though.

Kristen

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-06-26 : 02:58:54

quote:
Originally posted by damini_dd
I want to take back of on CD.

Better take the backup on the local disk, then copy to a network drive. Or go for a tape drive. I don't recommend CD.

------------------------
I think, therefore I am - Rene Descartes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources