June 8, 2007 at 6:52 am
All,
i have a server program that installs a microsoft SQL engine. but the main database has been marked suspect. is it possible to migrate the database to a full SQL server to recover it and then migrate back to its original location? i ask because the sql instance does not come with any tools to fix the DB
The server software is called Ariel it is a Document delivery service.
June 8, 2007 at 6:56 am
1.try to detach the db and reattach the db,it shud come online.........
2.else execute the following procedure .....sp_resetstatus 'DBName'.after exec it u need 2 restart the sqlservices.....then check whether the db is online
cheers
Deepak
[font="Verdana"]- Deepak[/font]
June 8, 2007 at 7:14 am
i am not sure how to issue that command. the SQL server engine did not come with any tools that i can can find. where should i run this sp_resetstatus
June 10, 2007 at 12:18 am
if u are able to login into query analzer,try the procedure sp_resetstatus.....and restart sqlservices.else if u can login into enterprise manager,right click on the particular db and detach it and reattach it........or u can use the procedure sp_detach_db 'DBName' ,'True'......and then attach it with sp_ attach_db 'DBName','Datafile path','logfile path'
Cheers
Deepak
[font="Verdana"]- Deepak[/font]
June 15, 2007 at 8:53 pm
HI,
could you provide us wat r all the db's are in offline mode, since if ur master db is in offline, then you cant start your sqlserver engine itslef. If msdb and model are in offline, then you can bring them online as said above with single user mode.
Regards..Vidhya Sagar
SQL-Articles
June 20, 2007 at 4:10 am
When you say your main database, if its master you have to rebuild then add your logins. etc, etc and then bring up the server. Else if its going to be your application database. well yo can restore from the previous backup if any, else can follow deepak's suggestion to reset the status to see if it somes online. most cases the database will not and you will have to restore from the previous backup.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 22, 2007 at 4:53 am
First thing Do you have application DB backup ? If Yes then install SQL Server once again and restore the user / application database from the backup
Minaz
"More Green More Oxygen !! Plant a tree today"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply