Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

write the query for taking database restore in sql?

Question Posted / sandeep thakur

Answer Posted / sandeep thakur

IN SQL SERVER 2005:-->

RESTORE DATABASE database name FROM DISK
='E:\Dailybackup\backupname.bak'
WITH MOVE 'database name' TO 'D:\database\databasename.mdf',
MOVE 'database name' TO 'D:\database\databasename.ldf',
REPLACE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update muliple row in single query?

1112

Differentiate between truncate vs delete in mssql?

1160

Can another user execute your local temporary stored procedures?

1023

What is the chart in report?

165

How to reaname table name without using sp_Rename in sql server..?

1038

What is the difference between varchar and varchar types?

1118

Tell me what is a linked server?

1084

How do I start sql server 2017?

984

How do you delete duplicate rows in sql server?

1002

Explain some stored procedure creating best practices or guidelines?

1001

Explain the relational database management system (rdbms)?

1161

How to create sub reports?

251

What is a covering index?

1040

What is "scheduled jobs" or "scheduled tasks"?

1026

How does the report manager work in SSRS?

158