I did a full backup of a db from one server(Express2005) and trying to restore it to a different instance of SQL2005 on the same development machine. (Also had some fulltext columns if that means anything)
Many failures but finally got it to report all was successful except the icon in Object Explorer shows (Restoring...) with no indication of any real activity going on. It's a tiny database with hardly any data in it.
Just not sure what the heck is going on there. It also won't let me into the database until this the (Restoring...) goes away.
Any advice on how to get this thing finished out?
can u post the script which u r used for backup and restore. did u use with Move option while restoring.
Madhu
|||Hi,
try
restore database <yourdatabase> with recovery
and as suggested plese post the script you used to restore database.
Hemantgiri S. Goswami
No comments:
Post a Comment