Master File not Accessible for Copying

[Zach]

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

[Dan Guzman]

Re: Master File not Accessible for Copying

Use a BACKUP DATABASE Transact-SQL command to backup SQL Server database
files. For example:

BACKUP DATABASE master
TO DISK='C:\Backup s\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.access iblewrote in message
news:45152c09$0 $742$5fc3050@dr eader2.news.tis cali.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
>
>

[Zach]

Re: Master File not Accessible for Copying

"Dan Guzman" <guzmanda@nospa m-online.sbcgloba l.netwrote in message
news:RYbRg.4502 $6S3.3904@newss vr25.news.prodi gy.net...

Use a BACKUP DATABASE Transact-SQL command to backup SQL Server database
files. For example:
>
BACKUP DATABASE master
TO DISK='C:\Backup s\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.