TIA. I have not opened a ticket yet as I believe this is an issue with me not understanding the limitations of SQL point in time restores vs a technical issue. We are backing up a SQL server daily with hourly logs. Our DBAs are using Enterprise Manager to test the restore functionality using logs as we have just recently enabled. The one DBA selected the database to restore, selected a time to restore on the slider, chose the same database server but a new database name. We have "Deny in-place database restores" enabled.
The result was that the job failed with the message "Failed to restore item newdatabasename (Type: Database; Source: Original_ServerName; Target: Original_ServerName) Database restore failed: The filename, directory name, or volume label syntax is incorrect"
Then the DBA checked and the database was altered then dropped by the Veeam service account when the restore was attempted.
Any ideas? Is it not possible to restore point in time with a separate name to the original server? Or should this be a support call?
-
- Expert
- Posts: 116
- Liked: 14 times
- Joined: Nov 26, 2013 6:13 pm
- Full Name: Michael Cook
- Contact:
-
- Chief Product Officer
- Posts: 31543
- Liked: 6714 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Point in time restore dropped database?
Yes, it should definitely be possible, so please log a support call (and keep us posted). Thanks!
Who is online
Users browsing this forum: Google [Bot], Gostev, Paul.Loewenkamp and 103 guests