|
Posted by Dan Guzman on 09/23/06 14:58
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.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Zach" <not@all.accessible> wrote in message
news:45152c09$0$742$5fc3050@dreader2.news.tiscali.nl...
> Re SQL Server 2005 Express
>
> When I attempt to copy the master file for backing up, it is being used by
> another application, even after shutting down the PC completely and
> powering
> it up again. What can I do to make back-ups?
>
> Zach
>
>
Navigation:
[Reply to this message]
|