Database restore (MS-SQL 2005) Does DB need to be off-line for a restore

Posted on 2009-12-30
Last Modified: 2012-05-08
Database restore (MS-SQL 2005)
Does DB need to be off-line for a restore?
Question by:LFreehauf
    LVL 5

    Accepted Solution

    No. It does not need to be Offline to restore.. I just did one sample.
    LVL 5

    Expert Comment

    Are you having any specific issues/concerns while backing up/restoring the database?

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Round up Or down 17 36
    Dataset not reading table data 12 37
    spx for moving values to new table 5 47
    sql calculate reminders 11 53
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now