Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deploying a Sql Server Database
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01299684
Message ID:
01299696
Views:
11
>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!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform