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

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

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:RYbRg.4502$6S3.3904@newssvr25.news.prodigy.ne t...
> 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.