As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to new filepaths. The answer, in short, is: RESTORE FILELISTONLY/ RESTORE WITH MOVE. Let’s say that you backed up the database ImportantDB from your production server, and you want to restore it to a test server. […]
Tip: RESTORE FILELISTONLY / WITH MOVE
- Post author By Jen McCown
- Post date
- Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, Tips
- 7 Comments on Tip: RESTORE FILELISTONLY / WITH MOVE