Answer / gtp

RESTORE DATABASE NewDatabase
FROM DISK='D:\Backup\NewDatabase.bak'
WITH
MOVE 'NewDatabase' TO 'D:\ActiveDB\NewDatabase.mdf',
MOVE 'NewDatabase_log' TO 'D:\ActiveDB\NewDatabase_log.ldf'

Answer / 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

What is nonclustered index with included columns ?

0 Answers  

---

What is postgresql server?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

How to include date and time values in sql statements?

0 Answers  

---

Does group by sort data?

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

How to include text values in sql statements?

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

How to generate create function script on an existing function?

0 Answers  

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---