•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,660 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,818 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 708 | Replies: 0
 |
•
•
Join Date: Feb 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Moving 2 databases over to a new server 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:
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 4:44 am.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
ad advertising ajax architecture asp backup beta business centro crash daniweb database dell developer development doubleclick enterprise google hacker internet linux longhorn mail microsoft mmorpg msdn news novell office open qmail red hat rhel security server smtp software source sql survey suse vista windows windows server
- learning php (PHP)
- SQL 2000 - getting data from two databases, same server (MS SQL)
- Financial Software Development Question (Computer Science and Software Design)
- PHP vs ASP... the big ShOwdOwN (IT Technologies and Trends)
- Exchange databases (Windows NT / 2000 / XP / 2003)
- Colo Server Management & Data Centers (Networking Hardware Configuration)
- Php? (PHP)
- Can my computer support this?!?!? (Motherboards, CPUs and RAM)
Other Threads in the MS SQL Forum
- Previous Thread: SQL Report Help
- Next Thread: PHP Mssql_Fetch_Array issues. Please HELP!!
