Re: backups retrieval



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: Mirror backup on SQL Server 2005
    ... If you want to overwrite a backup file on disk use WITH INIT instead. ... Andrew J. Kelly SQL MVP ... The remote server I am backing up to does not have SQL Server running it is ...
    (microsoft.public.sqlserver.server)
  • Re: Migration
    ... Andrew J. Kelly SQL MVP ... >>simple example to issue a Full backup of a database to ... >>Andrew J. Kelly SQL MVP ... >>> SQL Server Databases ...
    (microsoft.public.sqlserver.setup)
  • Re: Copying a Backup Set Using xp_cmdshell Fails
    ... Andrew J. Kelly SQL MVP "Girish" wrote in message ... Infact it Delete's the last backup from the target location. ... >> I need to copy this backup set over to a dev box for refresh every night. ...
    (microsoft.public.sqlserver.server)
  • Re: Backup Error - File in Use
    ... I have seen tape backup software hold ... Andrew J. Kelly SQL MVP ... In any case do you have a tape backup process that at some point ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)

Loading