Tuesday, August 28, 2012

Sql query to Restore Database

Hi All,
          These days i had come to a situation where i need  to restore large amount of DB .When I try restore Sql Sever GUI it is taking long time.Then with the help of below restore query it had almost saved lot if time

Restore DATABASE WSS_Content_ecdb178dc5434f4299f516abc83e48ed  From Disk = 'D:\sqldb.bak' With REPLACE