Moving 2 databases over to a new server

Expand Post »

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.

Similar Threads

learning php in PHP
SQL 2000 - getting data from two databases, same server in MS SQL
Financial Software Development Question in Computer Science
PHP vs ASP... the big ShOwdOwN in IT Professionals' Lounge
Exchange databases in Windows NT / 2000 / XP

nade

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: SQL Report Help

Next Thread in MS SQL Forum Timeline: PHP Mssql_Fetch_Array issues. Please HELP!!

DaniWeb Message

Cancel Changes

User Name
Password