Re: Saving .mdf database

Maury (maurizio.alberti_TOGLI_@xxxxxxxxx) 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@xxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: SQL Server Express - Detach & Shrink
    ... BCP can be invoked from SQL Server itself to export the file. ... what I need is some sort of single file to store numerical data. ... So when a user has finished with a database, I stream both the mdf and ldf ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to restore a database onto different server with mdf and ldf file only
    ... You could try attaching the database into another SQL server. ... > I have one critical database on it the MDF and LDF files are intact I ...
    (microsoft.public.sqlserver.server)
  • Re: Table Truncated (Urgent)
    ... My mdf file size 17 MB, ... Is there any way to retrive the data from LDF file. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Crashed C drive, but DB on D drive
    ... Can you tell the location of system databases MDF ... SQL server up with all the configurations and data same as old. ... Copy all the MDF and LDF files to the same directory stucture as before ... Restore the master database ...
    (microsoft.public.sqlserver.server)
  • Re: another newbie question, please help!! thanks
    ... .sql file. ... SQL Server? ... me with .mdf and .ldf files, which apparently are impossible to transfer, ...
    (microsoft.public.sqlserver.clients)
Loading