Thursday, 21 November 2019

Database Attaching Error in sql


Database Attaching Error in sql

CREATE
 DATABASE MyAdventureWorks  

    ON (FILENAME = 'D:\WINDB\PIANONEW.mdf'),   This is my .mdf  file path
    (FILENAME = 'D:\WINDB\PIANONEW.ldf')   This is my .ldf  file path
    FOR ATTACH; 


If  You are getting error on .ldf then remove .ldf from above code
this will help you

No comments:

Post a Comment