Re: backups retrieval



thanks. Very simple; cant believe I missed.

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:uyo7xoYZGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
Check out the section in booksonline for "CREATE DATABASE database_name
FOR ATTACH".

--
Andrew J. Kelly SQL MVP


"Raul Rego" <rrego@xxxxxxxxxx> wrote in message
news:uJLoVPVZGHA.4424@xxxxxxxxxxxxxxxxxxxxxxx
How do i bring a copy - MDF - file into my new MSSQL 2005 computer?

I know how to bring a backup - BAK - but I only have the MDF file.

Thanks,
Raul Rego
NJPIES





.



Relevant Pages

  • Re: installing *.mdf file and access is denied?
    ... Copying the mdf file is a good way to get inconsistency errors and is not a supported way to backup the database. ... server service, copy the file, and start the server again. ...
    (microsoft.public.sqlserver.server)
  • Re: bak file
    ... The backup file is an XLK file, ... 'Saves the current file to a backup folder and the default folder ... There is no option to change the .bak file's save directory. ... And I checked ADM File and support site, and Technet site, but I couldn't ...
    (microsoft.public.excel.setup)
  • Re: Maintenance Plan on SQL2005
    ... I denote my backup file name with a convention that tells me what type ... it is and the extension is always .bak. ... One plan for each folder unless you use SP1 then you can delete down one ...
    (microsoft.public.sqlserver.tools)
  • Re: restoring a database
    ... You should make a backup of the mdf file first, ... Need smaller SQL2K backup files? ... > Device activation error. ... restore database tmxvesta_dev file ...
    (microsoft.public.sqlserver.server)
  • Re: Database files and power failures
    ... disk LOCKED. ... The system makes a periodically backup of the database, ... the database service starts and try to open my ... How can I decide programmatically to use the complete mdf file or to restore ...
    (microsoft.public.windowsxp.embedded)

Loading