Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring a database on a broken installation
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Divers
Thread ID:
00443747
Message ID:
00443914
Vues:
12
>Larry:
>
>I always use the backup to file option as part of my maintenance plan. In the morning, they move the entire server to tape.
>
>When it comes time to restore, will it recreate all the database objects and move the data back too? Or do I need to script all the database objects first, then restore?
>
>Thanx,
>Charlie

The dump file is your whole database (all objects, users, data, etc.) so you don't need anything else.

Scripts are good if you want to move databases between servers with different code pages. You can use the generated script to create the database on the other server and use an exported version (e.g. comma delimited text) to get the data.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform