|
|
Posted by Zach on 09/23/06 15:42
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:RYbRg.4502$6S3.3904@newssvr25.news.prodigy.net...
> Use a BACKUP DATABASE Transact-SQL command to backup SQL Server database
> files. For example:
>
> BACKUP DATABASE master
> TO DISK='C:\Backups\master.bak'
> WITH INIT
>
> Not only does this allow you to take hot backups while the SQL server
> service is running, the backup file size is less than the database file
> sizes because only used space is backed up.
Thank you (done),
Zach.
Navigation:
[Reply to this message]
|