Physically moving the database to be used ona separate server

Question

Physically moving the database to be used ona separate server

f05338609

SSC Rookie

Points: 47
More actions
April 24, 2009 at 3:50 pm

#202420

For my dissertation at University i have created a database in SQL Server Express 2005 to act as the backend for the prototype i am developing. I have used Access as the frontend and everything is working fine with the tables linked etc.
My issue now though is that i need to submit the work (the prototype) and i am unsure how to do this. Having spoken to my supervisor he said to put the two databases on a CD and in the report provide instructions as to where the specific folders need to go on the assessor/marker(s) hard drive.
Basically i want to transfer the database i have from my SQL Server into a completely separate SQL Server on a separate machine.
Can anyone recommend an appropriate solution to this problem please?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Backup/restore is probably easiest. Put a backup on the CD with instructions on how to restore. You'll also have to explain how to relink the access tables, as they refer to the source server by name.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

f05338609 SSC Rookie Points: 47 More actions · Answer 2

Thank you very much. Yeah i was thinking that i would probably need to include a guide for re-linking the tables also so thanks for confirming that for me.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You should probably also include a quick installation guide for SQL Express, in case the marker doesn't have it already installed

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

f05338609 SSC Rookie Points: 47 More actions · Answer 4

Thanks again. Yeah it was something i was considering adding into my appendices and referring to in the report, a user guide for both Access and SQL Server so i will probably go ahead and do this.

Thanks for your help again, it is greatly appreciated.

rburgess Old Hand Points: 327 More actions · Answer 5

You could also try detatching the databases, copying the MDF and LDF files to a CD, then reattaching them on the source server. Then copy the MDF and LDF files to the new server and attach them there. That would preserve all settings.