MSSQL Directory look up for .mdf failed | Information technology and notes about it.

Feb 8, 2016

0 MSSQL Directory look up for .mdf failed

Fix for : System.Data.SqlClient.SqlError: Directory lookup for the file "C:\~\DB.MDF" failed..

Perform backup restore using T-SQL:

RESTORE DATABASE LNE FROM DISK = 'C:\LNE-22012016.bak'
WITH MOVE 'LNE' TO 'C:\SQL_data\LNE.mdf',
MOVE 'LNE_log' TO 'C:\SQL_data\LNE.ldf';

Example :

0 comments :

Post a Comment

Comment:

Subscribe to: Post Comments ( Atom )