Timeline for SQLServer: Backup a database on a server and restore it on another server
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2018 at 12:40 | comment | added | Aaron Bertrand |
Does the staging server have the same instance name and the same data path? If not you'll also need WITH MOVE because once you're able to access the backup, you'll need to make sure the restore directs the files to the right location on the staging server.
|
|
| Nov 13, 2018 at 10:57 | answer | added | Thomas Kronawitter | timeline score: 2 | |
| Nov 13, 2018 at 10:27 | comment | added | John K. N. | What are the versions of your SQL Server installations? What are the Editions (Enterprise / Standard / Web / Express / ...) of your SQL Server installations? Please add this information to your question either as text or as tags. Thanks. | |
| Nov 13, 2018 at 9:48 | history | asked | Bastien Vandamme | CC BY-SA 4.0 |