Comprehensive data protection for all workloads
Post Reply
Nordialog Borg
Lurker
Posts: 2
Liked: never
Joined: Aug 01, 2013 7:37 am
Full Name: Nordialog Borg
Contact:

Is it possible to use SQL Management studio to restore?

Post by Nordialog Borg »

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
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. »

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!
Post Reply

Who is online

Users browsing this forum: Bing [Bot], brodyk, Semrush [Bot] and 257 guests