Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL recovery from database files

Posted on 2009-04-07
2
Medium Priority
?
181 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:fcnetimg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Expert Comment

by:dportas
ID: 24096205
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.
0
 
LVL 1

Accepted Solution

by:
fcnetimg earned 0 total points
ID: 25350682
There is no option to use SQL restore processes to recover a copy of the live database.  That only works with a SQL backup.  In the case of working with this block-level image like backup, the only option for recovery is to shut down the SQL server services and replace all of the applicable files from the backup copy.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question