Software

Ask something
Discussion Locked

SQL 2000 Server Attach database fail

0 helpful
1 reply

by berkimdgkr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a MS SQL 2000 database. Recently It has size problem. I used sp_resetstatus for clearing status. Then detach the database for moving bigger HDD. When I tried to re-attach the database, it gave error 3524. I couldn't attach database. How can I solve this problem?

1 reply

by barneyrubble318

Make sure your database devices are as big as the original. You will also need the same number of devices as the original, so if you had one mdf, several ndf, and an ldf, you will need to recreate all the ndf's.

This discussion is closed to new replies.