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...



I hope it help you!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.