<div>
You need to check with the backup solution vendor. Unless their product is SQL Server aware then you can't expect anything like the protection you get from SQL Server backups with point in time recovery. Backup vendors often provide DBMS support as a separate product or optional module.
</div>


You need to check with the backup solution vendor. Unless their product is SQL Server aware then you can't expect anything like the protection you get from SQL Server backups with point in time recovery. Backup vendors often provide DBMS support as a separate product or optional module.

<div>
<div class="content wysiwyg-content">
I have a backup system which captures data at the block level, essentially providing me with a snapshot of the server hard drive at a given point in time. &nbsp;This provides me with copies of the actual SQL databases and logs as they were at a pojnt in time. &nbsp;Since these are not database and transaction log 'backups', I am not able to use traditional 'restore' methods like RESTORE DATABASE. &nbsp;I figured out that I could shut down the SQL services ortake the database offline and replace the database and transaction log files on the server with the ones I had backed up. &nbsp;I'm wondering if there is any better way to do this type of recovery. &nbsp;The test I did was on a simple recovery test database, but I'm not sure how I would be able to roll back transaction logs or recover the metadata databases like master, model, msdb with what I have.
</div>
</div>


I have a backup system which captures data at the block level, essentially providing me with a snapshot of the server hard drive at a given point in time.  This provides me with copies of the actual SQL databases and logs as they were at a pojnt in time.  Since these are not database and transaction log 'backups', I am not able to use traditional 'restore' methods like RESTORE DATABASE.  I figured out that I could shut down the SQL services ortake the database offline and replace the database and transaction log files on the server with the ones I had backed up.  I'm wondering if there is any better way to do this type of recovery.  The test I did was on a simple recovery test database, but I'm not sure how I would be able to roll back transaction logs or recover the metadata databases like master, model, msdb with what I have.

SQL recovery from database files

The Domain Name System (DNS) is a hierarchical, globally distributed system responsible for associating the name of a computer, service or other resource into an IP address for connecting to the Internet or a private network. Most prominently, it translates domain names to the numerical IP addresses needed for the purpose of computer services and devices worldwide.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.