- Posts: 5
- Liked: never
- Joined: Feb 23, 2010 10:18 pm
- Full Name: Doug Gilmour
Another SQL question.
What is the proper procedure for restoring a database to an exact point in time? Typically, we restore the database from a full backup without recovery, then roll forward a transaction log restore to an exact moment we want.
How will I need to configure Veeam to be able to accomplish this? From what I have read about VSS and the SQL 2005 writer is that Transaction logs are not considered and that I'd have to use "traditional methods". Does this mean I should setup the backup job to run a pre- command that will dump the SQL transaction log to a file, then snapshot the VM so I capture it. The restore procedure would be to restore the .mdf and .ldf from the night before, then the transaction log backup file (trn) and restore to the point in time from that? Will Veeam restore with NORECOVERY?
- SVP, Product Management
- Posts: 29506
- Liked: 5597 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
I know very little about "traditional" SQL backups, but I know we have many customers backing up virtualized SQL servers, and most of them probably have some "traditional" SQL backup experience - so hopefully someone can give you additional details on this.
Users browsing this forum: Baidu [Spider] and 26 guests