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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 database backup

Author  Topic 

imughal
Posting Yak Master

192 Posts

Posted - 2005-01-12 : 10:14:30
i need to take database backup using TSQL. how do i do that.
i took database backup using enterprise manager . EM shows database size around 5 MB but when i took database backup through EM the database backup size reach to 25 MB. i don't know why size goes so much high. might it also taking transaction backup.

kindly tell how i can take database backup as with original size plus using TSQL

regards,
Iffi

nr
SQLTeam MVY

12543 Posts

Posted - 2005-01-12 : 10:53:20
A full backup includes part of the tr log necessary to do a restore.
How big is the tr log? Try taking a tr log backup or setting the recovery model to simple.see
http://www.mindsdoor.net/SQLAdmin/TransactionLogFileGrows_1.html

For a backup
backup database mydb to disk='c:\mydb.bak'
see
http://www.mindsdoor.net/SQLAdmin/BackupAllDatabases.html
to backup all databases

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -