-
restore master database error why?
RESTORE DATABASE must be used in single user mode when trying to restore the master database.
________
Maine Marijuana Dispensary
Last edited by sql; 03-06-2011 at 01:56 AM.
-
Yep. You need to be on single user mode.
goto command prompt [Start-run-cmd.exe - Enter] and type the following.
net stop mssqlserver
if it is named instance then
net stop mssql$yourinstancename
sqlservr -m
then use ISQLw or osql to restore the master database.
-
Hi Mak,
Thank you for the relpy
C:\Documents and Settings\Administrator>net stop mssqlserver
The MSSQLSERVER service is stopping.
The MSSQLSERVER service was stopped successfully.
then ?? recently we update from Windows XP to Windows server2003 it seems something wrong, I alway got table is not invalid and store procedure is not there? but if I run it on sql enviroment the table and procedure run fine, is that possible the master database did not work fine??
that project run almost one year and every thing fine , untill recently we update the system. please help!
________
JEEP COMANCHE SPECIFICATIONS
Last edited by sql; 03-06-2011 at 01:56 AM.
-
Steps involved in restoring the master database.
step1
Goto Command prompt Start-run-cmd.exe - Enter
step 2
net stop mssqlserver
step 3
sqlservr -m
step 4
isqlw or osql.exe or isql.exe
step5
restore command.......
When you say project, what kind of project?
Its not always the database is broken. Check with your application programmer on any issues while updating an xp to windows 2003.
did you run service pack on the server after updating from xp to windows 2003?
-
on Dos or on database?
what kind of project?
jdk + tomcat + Ms sql search engine,
before we run sql server 2000 personal edition on xp (we update to sql server package 4) we did have standard edition , but the Cd is broken.
but I did not which jdbc driver I should use I try the driver for Ms sql server package 2
I guess the database is broken, since I try to stall an uninstall databse few time, some time this park work fine some time other park, and always get storeprocedure is can't found or table is invalid. is that possible other problem?
thank you!
________
Honda ns500
Last edited by sql; 03-06-2011 at 01:56 AM.
-
Need more details like Full error message. Since you are using full text search, need more info on error message from full text search index.
Did you install the latest sql server service pack on that server after updating xp to windows 2003?
Do not conclude that it is a database problem.
-
Don't think it's master db issue, you have to ensure you run the query in correct db. When you build connection string, have to include correct db name in the string.
-
hi all,
thank you
I use the evaluate sql2000 and update it to server package 4, Since our sql 2000 server package i standard edition is on the way. i did have the coeeect db name in the string, by the way I got
sqlservr' is not recognized as an internal or external command,
perable program or batch file. when I run sqlservr -m
on DOS.
Thank you
________
HASHISH
Last edited by sql; 03-06-2011 at 01:56 AM.
-
Change directory to where sqlservr is and run the commad there.
-
HI all,
Thank you for the reply.
the old problem get fix, you are guys are right, is not the mast database problem, my connection string have a space in there, it is ok in XP, but is not OK on Windows server 2003, the strang thing is some function work fine and other not, even the all have the same connection pool, I don't why the only thing I know is when I take away the space on those unwork function. Now the whole project work!
But I still have question on
1) on step 4 I run isqlw, I can't login with any user name or password even the sa and the password which I set up on my install. What can I do?
2) can I use kill id to instead the steps Mak tell me?
3) How to get more information on full index search?
Thank you for all your kindness.
________
VIPER E85
Last edited by sql; 03-06-2011 at 01:56 AM.
-
1. Double check sql server properties in enterprise manager to see if sql only accepts windows authentication.
2. Yes you can, but have to find out all spids.
3. What kind of info? How to setup? Check books online.
-
not, since my sql connect to application, I can't choose win authoration.
Thank you
________
Captiva
Last edited by sql; 03-06-2011 at 01:56 AM.
-
Then you have to make sure you enabled sql authentication on the server.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|