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 15:48:06
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
07/02/2008 13:45:05
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00877904
Message ID:
01290587
Vues:
10
Good, looks like you have choices.
Tim

>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
Timothy Bryan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform