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
 Transact-SQL (2000)
 database backup using TSQL

Author  Topic 

imughal
Posting Yak Master

192 Posts

Posted - 2005-01-12 : 10:29:01
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:56:07
Dup post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44614

==========================================
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

imughal
Posting Yak Master

192 Posts

Posted - 2005-01-28 : 01:52:55
good
Go to Top of Page
   

- Advertisement -