Pages

SqlServer Database BackUp and Restore

1) Copy 2 files. from SouceSystem Databasename.mdf , Database.ldf from installed sql server folder (path:c:\program files]microsoftSql server\Data\datbasname.mdf) 2) Create a Database in Destination system . 3) Past 2 file in installed sql server location (path:c:\program files]microsoftSql server\Data\datbasname.mdf) 4) Right click on destination database then click to attach datbase/files 5) Select appropriate databasename. mdf file Note:Assume sql server installed in C Drive .Path can vary