MS SQL

Moving 2 databases over to a new server

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2007

Posts: 1

Reputation: nade is an unknown quantity at this point

Solved Threads: 0

nade

Offline

Newbie Poster

Moving 2 databases over to a new server

Feb 21st, 2007

OK, I'll admit straight away i'm new to SQL.

I've got a SQL 7 Server with two small databases running. I have been able to backup both to file. However when I try and "restore" them on a test SQL 2005 Server, it errors because the file & folder structure is different.

On the SQL 7 server, the two existing databases sit in a folder on a F: partition. My test server doesn't have a F: partition, i've just left it all on C:

Thanks for reading :cheesy:

Last edited by nade; Feb 21st, 2007 at 5:44 am.