I have a database, of which I made a backup, that I can't restore. When I try to restore it (using Enterprise Manager), everything seems to work fine, except when there are only two boxes left (in the progress bar), everything seems to stop there.
I went to the server, and it's hard drives are working, but even after 15 minutes, it is still stuck there. So I ended up pressing stop, which made my database invalid - as expected.
Fortunatly, I had a copy of that database under another name, but trying to restore the copy unto the original gives me the same result (that copy was backuped with the verify option). Same thing if I try to restore the copy as a new database. I thought it might be something with the SQLServer installation, so I backuped Northwind and restored it as a new database - works fine, takes about 7 seconds for the restore operation.
Ok, so I used the filelistonly option of the restore command, and I saw that the transaction log is 10 times bigger than the data. I thought that might be the problem, so I truncated the transaction log, re-backuped the second database, and tried restoring - same result... and the filelistonly option still shows a log 10 times bigger than the data!
Anyone knows what's going on? Is it normal to take long to restore a backup? Any ways to copy a database other than backing it up and restoring?
Obviously, I'll have to solve that restore problem, but right now, I could settle with just beeing able to copy my database because we've been stuck since yesterday with that problem...
Thanks!
Sylvain Demers