Database restore with REPLACE avoiding MOVE

11-12-2007, 04:46 PM

When restoring a full database backup into an existing database, WITH
REPLACE is used to overwrite the existing target database. This
suggests that the physical path and file name for the data and log
files of the target database will be overwritten. However, error
message 1834 indicates that an explicit MOVE needs to be done of the
physical data and log files, eventhough those are already known.

How do you restore a backup into an existing database, automatically
using the target's physical files and avoiding MOVE?

11-12-2007, 04:46 PM	#1
j.roumimper@gmail.com Guest Posts: n/a	Database restore with REPLACE avoiding MOVE When restoring a full database backup into an existing database, WITH REPLACE is used to overwrite the existing target database. This suggests that the physical path and file name for the data and log files of the target database will be overwritten. However, error message 1834 indicates that an explicit MOVE needs to be done of the physical data and log files, eventhough those are already known. How do you restore a backup into an existing database, automatically using the target's physical files and avoiding MOVE?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

New To Site?	Need Help?
Register to Participate Meet our Staff Refer Forum Rules Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read

Database restore with REPLACE avoiding MOVE

Microsoft SQL Server