Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying databases, tables in sql server dev edition
Message
De
07/02/2008 13:45:05
 
 
À
06/02/2008 12:55:29
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00877904
Message ID:
01290525
Vues:
11
Detach and attached worked.
Also... check out what Bonnie suggested. That worked also.

Thanx
Neil

>Hi Neil,
>
>>
>>I have been using this trick of yours since 2004. Thank you ever so much.
>>
>>But today I have a new problem and I was hoping you could help once again. Server B is running the old sql server 2000 and contains NORTHWIND , which I modified. Server A has a fresh install of the new sql server 2005. When I attempt to run this trick of yours, sql server 2005 indicates that the the file that I am attempting to restore onto it is not a database file or is missing some components. Any thoughts? Please be gentle in your explanation. I am a vfp developer and know very little about sql server.
>>
>>Neil
>>
>
>What if you upgrade server A first before detaching the file? How about if you do a detach and attach rather than a backup and restore?
>
>Tim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform