Posted by Erland Sommarskog on 04/10/06 10:29

Maury (maurizio.alberti_TOGLI_@gmail.com) writes:
> 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?

I'm not sure that I understand. What would the purpose be for this
operation? It sounds to like you are looking for the BACKUP command.
Which will not save your .mdf and .ldf files, but save a consistent
backup of the database.

Normally, you should leave the .mdf and .ldf files alone.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Saving .mdf database
• Prev in forum: Re: Re-display result set without re-running query in Query Analyzer?
• Thread view: Re: Saving .mdf database

[Reply to this message]