General discussion

Locked

SQL 2000 Restore To Different Location

By TheWrightMan ·
OK. I have a good one. I have the following setup:

ServerA
Data on: C:\Data
Log on: C:\Logs

ServerB
System Databases on: \SysData
Data on: E:\Data
Indexes on : \Indexes
Log on: F:\Logs

So, what I want to do is restore a database from ServerA to ServerB. Placing the files and data in the correct locations. I want the data in a filegroup called DatabaseName_Data. Problem is when I restore to ServerB, the data always goes to PRIMARY filegroup during restore. The only thing I can find is to manually change the location of the data for each table in Enterprise Manager (YUCK!)

Barring that option, is there a way to move the data from the PRIMARY filegroup to a newly created DatabaseName_Data filegroup?

Isn't there an easier way?

Thanks for the help

Darrell

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums