Bad Credit Mortgages - Mortgage - cPanel Hosting - Credit Cards - Personal Loans
PDA

View Full Version : Updating a production database with back up of development database

forumposters
May 8th 2007, 9:15 am
Can someone please point me to step by step instructions on how this is done?
forumposters
May 9th 2007, 3:19 pm
By the way, I'm asking about SQL Server 2005.
gibex
May 14th 2007, 3:30 pm
http://www.google.ro/search?hl=en&q=restore+database+mssql&btnG=Google+Search
Clark Kent
May 16th 2007, 2:06 pm
Stop development sql server.
Copy your database files (mdf and ldf) to production sql servers database directory.
Open Enterprise manager and attach your database. you can use also sp_attachdb stored procedure but enterprise manager GUI is easyier.
Don't forget to start your development server :)