Is it possible to use SQL Management studio to restore?

Availability for the Always-On Enterprise

Is it possible to use SQL Management studio to restore?

Veeam Logoby Nordialog Borg » Wed Nov 30, 2016 10:01 am

Hi,

I noticed that in SQL Management studio i could see the Veeam SQL backups when I tried to restore from a point in time.
However, if I select one of these backuppoints (as opposed to the Management studio-backups), it would fail with an error, saying that the file cannot be found.
I suppose that the Veeam backuppoints show up because Veeam uses VSS to backup, and this somehow gets registrered with Studio, but when Veeam is finished with the backup, the snapshot is closed, and no longer accessible. Studio however does not remove it as a point in the timeline.
Is there a way to get Studio to access the Veeam backups in another way?

Anders
Nordialog Borg
Lurker
 
Posts: 1
Liked: never
Joined: Thu Aug 01, 2013 7:37 am
Full Name: Nordialog Borg

Re: Is it possible to use SQL Management studio to restore?

Veeam Logoby Vitaliy S. » Wed Nov 30, 2016 1:41 pm

Hi Anders,

If you want to use SQL Management studio to do the restore, then you need to manage transaction logs natively within the app. In other words, do backups locally, back up the entire VM and upon the restore process launch SQL Management studio to do all the job.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19542
Liked: 1098 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: eric.siedentopf, fazerren, Yahoo [Bot] and 55 guests