How to attach SQL 2000 database (MDF) without a LDF file.
Posted on 2006-05-31
I have a big problem, hope that you can help...
I have windows 2003 server with CA brightstor 11.0 (Build 2670)
and is making backup to all my SQL Servers.
so I need to restore a database where the MDF file is 4 GB and the LDF file 111 GB.
So right now I already restore the MDF file of 4 GB. but I cannot restore the LDF file..
So I want to attach this MDF file to a test server that have SQL 2000 with SP4.
so I check in this site how to restore the MDF to SQL but not good luck...
can someone help.. how to attach the MDF file on the query analyzer..
if I miss something that cannot be understand , please let me know...