forum.venkateswarlu.net
      Register      Login
Error in Restoring Database mdf and lof.File activation failure. The physical file name

2 replies to this topic

Satyabrat Sahoo #1
Member
18 Points
 Posted on 09 Jul 2012 07:10 AM IST While restoring database(I have mdf and ldf file with me) i am getting such error



File activation failure. The physical file name "F:\Malappuram_2011 Final
Data\FINAL_MALA_2011_SAT\FINAL_MALA_2011_SAT_log.ldf" may be incorrect.
New log file 'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\sample\testT_log.LDF'
was created.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'test'. CREATE DATABASE is
aborted.
File activation failure. The physical file name "F:\Malappuram_2011 Final
Data\FINAL_MALA_2011_SAT\FINAL_MALA_2011_SAT_log.ldf" may be incorrect.
Msg 5170, Level 16, State 1, Line 1
Cannot create file 'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\sample\test_log.LDF'
because it already exists.
Change the file path or the file name, and retry the operation.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'test'. CREATE DATABASE is
aborted.
 
SQL Server     1488 views     Reply to this topic
Satyabrat Sahoo #2
Member
18 Points
 Replied on 09 Jul 2012 07:19 AM IST Can Any1 Help me to restore this database?Its Little bit urgent? 
Reply to this topic
Satyabrat Sahoo #3
Member
18 Points
 Replied on 09 Jul 2012 07:21 AM IST CREATE DATABASE test ON
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\test.mdf')
FOR ATTACH
.....................................................
create database test
on(filename= N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\sample\test.mdf')
for attach_rebuild_log;


I used these two queiry for restore but its showing error 
Reply to this topic