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" <no*@all.accessiblewrote in message
news:45********************@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