Query

Posted Date: 21 Oct 2008 Posted By: Vasundhara Member Level: Gold Points: 1 Responses: 3

Hi All,

Can anyone tell me the query for the following scenario. how to restore a database

You have performed backup on your databases. Everything was working just fine until this morning; when you came in this morning, the users are complaining that they can’t access the database. You try to open the database in SQL Server Management Studio but can’t. You know instantly that the database is down and needs to be restored, so you have decided to start the restore process.Restore your database with a new database called Sales_After_Restore.

Thanks in advance...

Responses

Author: lakshmi Narasimhulu 21 Oct 2008

Member Level: Gold

Rating:

Points: 2

http://articles.techrepublic.com.com/5100-10878_11-1041267.html

Author: Ashokkumar 21 Oct 2008

Member Level: Gold

Rating:

Points: 2

Hi Vasundhara

Use this query

restore database 'your database name'

From disk ='backup location for .bak file '

for ex

restore database 'SampleDB'
from disk = "c:\programfiles\mssql1.1\master.bak'

Thanks

Author: madhavi 25 Oct 2008

Member Level: Gold

Rating:

Points: 2

open this link we can some idea

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : import Excel file into sql server 2000 table
	Previous : Stored Procedure
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use