Hi, Can I directly backup database files use windows backup program? thanks.Short answer is no. You need to use the SQL Server BACKUP command to create
a backup file which you can then backup with windows etc.
--
Andrew J. Kelly SQL MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:eRVYRwPlEHA.3520@.tk2msftngp13.phx.gbl...
> Hi, Can I directly backup database files use windows backup program?
thanks.
>|||Longer answer...
While SQL Server is running, the mdf, ndf and ldf files are open and in use.
Using SQL Server backups will create backup files which will then be
"offline" and you can use another tool to back these up. You could take SQL
Server offline and then perform the backups of the database files, but this
is not recommended.
Rick Sawtell
MCT, MCSD, MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uOaSWEQlEHA.3452@.TK2MSFTNGP15.phx.gbl...
> Short answer is no. You need to use the SQL Server BACKUP command to
create
> a backup file which you can then backup with windows etc.
> --
> Andrew J. Kelly SQL MVP
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:eRVYRwPlEHA.3520@.tk2msftngp13.phx.gbl...
> > Hi, Can I directly backup database files use windows backup program?
> thanks.
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment