Timeline for Only a single WITH MOVE clause should be specified for any logical file name
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 3, 2012 at 16:02 | history | tweeted | twitter.com/#!/StackDBAs/status/275631042851901441 | ||
| Dec 3, 2012 at 15:40 | vote | accept | Lumpy | ||
| Dec 3, 2012 at 15:40 | review | Close votes | |||
| Dec 3, 2012 at 16:15 | |||||
| Dec 3, 2012 at 15:31 | comment | added | Remus Rusanu |
You move the logical file (by name). Not the backup name, nor the database name. You retrieve the name of the file(s) in the backup using RESTORE FILELISTONLY
|
|
| Dec 3, 2012 at 15:29 | answer | added | Thomas Stringer | timeline score: 5 | |
| Dec 3, 2012 at 15:22 | history | edited | András Váczi |
edited tags
|
|
| Dec 3, 2012 at 15:20 | comment | added | Lumpy | Isnt backup name supposed to be the name of the backup database? Or do I need to specify that it is the backup databases mdf and ldf files respectively? | |
| Dec 3, 2012 at 15:17 | comment | added | Remus Rusanu | You're moving the same thing ('@BackupName') twice | |
| Dec 3, 2012 at 15:12 | history | asked | Lumpy | CC BY-SA 3.0 |