We can restore AdventureWork2012 Database onto our SQL
SERVER 2012. We can easily do this by writing a Simple T-SQL query. We can get and
download MDF file for SQL Server 2012 in the following link.
CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'C:
\dhinakaran\acer\AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG
FOR ATTACH_REBUILD_LOG
Where 'C:
\dhinakaran\acer\AdventureWorks2012_Data.mdf’ is the path of my MDF
file. The log files are also available
on Microsoft site and if it’s not found, no worries, this query however will
start with new Log File.
While restoring AdventureWork2012, we may come
across some errors. Most common one is
Msg 5133, Level 16, State
1, Line 1
Directory lookup for the file “'C: \dhinakaran\acer\AdventureWorks2012_Data.mdf’” failed with the operating system error 5(Access is denied.).
Directory lookup for the file “'C: \dhinakaran\acer\AdventureWorks2012_Data.mdf’” failed with the operating system error 5(Access is denied.).
Solution: Go to your MDF file and Right click on
it and select properties. Then go for security and click edit.
Now select Full Control option and give apply and
rerun the Above SQL Query.
And other common issue is
‘Msg 1813, Level 16, State 2, Line 1
Could not open new database ‘AdventureWorks2012′. CREATE DATABASE is aborted.
Msg 948, Level 20, State 1, Line 1
The database ‘AdventureWorks2012′ cannot be opened because it is version 705. This server supports version 655 and earlier. A downgrade path is not supported.’
Could not open new database ‘AdventureWorks2012′. CREATE DATABASE is aborted.
Msg 948, Level 20, State 1, Line 1
The database ‘AdventureWorks2012′ cannot be opened because it is version 705. This server supports version 655 and earlier. A downgrade path is not supported.’
This can be solved by moving your MDF file to C:\ProgramFiles\MicrosoftSQLServer\MSSQL11.MSSQLSERVER\MSSQL\DATA) and
run the Management Studio as Administrator
Comments
Post a Comment