|
|
Posted by Greg D. Moore \(Strider\) on 04/10/06 13:37
"Maury" <maurizio.alberti_TOGLI_@gmail.com> wrote in message
news:gCn_f.75203$PR2.1228292@twister2.libero.it...
> Hello,
> I use SQL Server 2005 Express and I would like
> to save on db of mine...
> Have I only to save the .mdf and .ldf data file
> or I need to stop some service or other programs?
> Can I use some utility to schedule this?
Most likely you want to issue a command like:
BACKUP DATABASE <dbname> to disk='x:=\backups\dbname_yyyymmdd.bak'
Look up details in Books Online.
If you really want to take the DB off line, do a NET STOP command and then
back up the files followed by NET START.
(I'm not sure of the SQL Server Express service name since I can't get it to
install on my desktop.)
> Thanks
> M.
Navigation:
[Reply to this message]
|