Click here to Skip to main content
14,983,411 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am using Windows 8. I want to restore 2005 back up file on SQL Server 2012. SQL Enterprise Manager can't install in my computer. Help Me.
DamithSL 2-Jun-14 23:50pm
Any errors?

In options tab you have a check box that says close existing connections to destination datatbase. Have you checked that one?
Ye Htut 3-Jun-14 0:36am
that check box is not enable. :(
Use this query:

FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\South.BAK'
MOVE 'SouthWind_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SouthWind_Data.MDF',
MOVE 'SouthWind_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SouthWind_Log.LDF'

where FromDisk is where the .bak file is kept on Server B and MOVE specifies the location of the data and log file.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900