Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transferring database to MSDE for use on laptop...
Message
De
21/01/2003 22:18:44
 
 
À
21/01/2003 16:58:48
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00743862
Message ID:
00744110
Vues:
17
Just to make sure I understand ...

I can backup from Computer A, then restore to Computer B without generating the database before hand.

Is this correct?


>6.5 required that the database exist with the same segments as the original database. Since 7.0, the database contains the information needed to recreate itself.
>
>-Mike
>
>>That won't quite work. He needs a database on the laptop for the restore.
>>
>>1. Generate a SQL script file on the desktop that will recreate the database.
>>2. Edit any file locations, user ids, etc in the SQL script file.
>>3. Run the SQL script file on the laptop
>>4. Backup the database
>>5. Copy the backup file to the laptop
>>6. Restore the database.
>>
>>
>>>If you know how to back up the main database to a file, all you need to do copy that file to your laptop, and restore that same file to your MSDE machine. Just be aware that the database locations (2nd tab after selecting the file) point to the file on your laptop or you'll get an error. All of this can be done while your main database is online.
>>>
>>>HTH
>>>
>>>Chuck
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform