To use this script, only an S:\ drive is needed (the path can be changed) to create the sample database and put in a SQL Server Agent job to automatically run a few stored procedures that will insert and delete random data. I put three (and a deleted script) up on the Veeam Github site.
To help this process, I created a few scripts to help individuals learn this type of interaction with SQL Server.
#VEEAM BACKUP SQL SERVER WINDOWS#
Additionally, Veeam Backup & Replication and the Veeam Agent for Microsoft Windows also provide an image backup of the entire system.įor those who are not a DBA, sometimes dealing with low-level SQL Server topics can be a bit overwhelming.
This is a great combination of functionality from the established application-aware image processing with a dedicated tool for database restores in Veeam Explorer for Microsoft SQL Server. Additionally, you can also restore the databases to a specific transaction. Veeam Explorer for Microsoft SQL Server allows application-specific restores of SQL databases, and also contents of tables, objects such as stored procedures, views and more. That’s why I took particular interest in Veeam Explorer for Microsoft SQL Server that came in Veeam Backup & Replication. Since I’ve been at Veeam, I have always enjoyed telling the Veeam story around using SQL Server as a critical application that needs the best Availability options.
While I did not call myself a database administrator (DBA), I did know my way around a database or two. Believe it or not, I used to work a lot with Microsoft SQL Server.
0 kommentar(er)
