>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!
____________________________________