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.
Posted
Comments
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?
   
Comments
Ye Htut 3-Jun-14 0:36am
   
that check box is not enable. :(
SQL
Use this query:

RESTORE DATABASE [SouthWind]
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\South.BAK'
WITH REPLACE,
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