Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deploying a Sql Server Database
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01299684
Message ID:
01299696
Vues:
12
>I have a SQL server Database which I am ready to deploy out on site,and am not sure of exactly what to do next:
>Do I
>Make a Backup (In Sql Server management studio)
>Send out to site
>
>If the site has Sql Server management Studio. is it just a matter of restoring the database, ot do they have to set anything up on their end ?
>
>Any help appreciated
>
>Regards,
>Gerard

If you have dbo rights then you are essentially correct. When restoring on the target server make sure you specify where you want the MDF and LDF files to go in case they need to be on a specific volume (like a RAID volume).

You probably will also need to create logins on the target server to match the logins in your database or vice versa.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform