Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Attaching a Database
Message
 
 
À
30/11/2006 09:38:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01173673
Message ID:
01173700
Vues:
7
You can use RESTORE FILELISTONLY to see if it's a backup.

>Good point, Sergey. I didn't think it was a backup as it had a .DAT extension. I tried restoring it and it seems to have worked!
>
>
>>You cannot attach SQL Server backup, you've to RESTORE it.
>>
>>>
>>>I asked a client to send me a backup of their SQL Server database. I received a .DAT file! Now, I'm not sure what I can do with this. I tried Attaching it to my SQL Server, but got the message that this is not a primary database file.
>>>
>>>Is there anything I can do with this file? Or do I need to tell them to do a backup using the SQL Server Management Studio (or whatever is the equivalent for the version of SQL Server they have)?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform