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.

[Back to original message]