Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2009-12-30
2
Medium Priority
?
203 Views
Last Modified: 2012-05-08
Database restore (MS-SQL 2005)
Does DB need to be off-line for a restore?
0
Comment
Question by:LFreehauf
  • 2
2 Comments
 
LVL 5

Accepted Solution

by:
chinawal earned 2000 total points
ID: 26151663
No. It does not need to be Offline to restore.. I just did one sample.
0
 
LVL 5

Expert Comment

by:chinawal
ID: 26151670
Are you having any specific issues/concerns while backing up/restoring the database?
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Integration Management Part 2
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

810 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