SQL Server Performance Forum – Threads Archive

Problem In SQL Service

Hi, I just change the sql server startup parameter I like to change the system databaes but I had to backup due to some after stop the instance I’m not able to master database files move to another location. After I specified the previous parameter as like before. As I’m just trying to run the SQL Server but I’m following the error is given below: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details" SQL Server 2005 have rebuild database utility as like we use the utility on SQL Server 2000. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]I hope anyone will provide me a good solution. Amit Kumar Mob.: 9873812005

Your error indicates that something has gone wrong with your data files location or start up parameters. But what you have done is not clear in your message. First, have you changed the start up parameters? Second did you move your data files to new location or not? Satya

First of check your sql error log and appliation/system log for more details beucase the error you got is generic one… Check the following and make you follow the directions specified… SQL Server 2005 Books Online
Moving System Databases
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
If you want to rebuild the master….
SQL Server 2005 Books Online
How to: Rebuild the Master Database for SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms143269.aspx
http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

If the system configuration doesn’t matches with the file location such as master or msdb then you would get such error and also ensure the Service account has relevant privileges to access those files n the specified location. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Hi, [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]Thanks you very much everybody for help. I have resolved the problem I just specified the wrong path therefore error was coming. Amit Kumar Mob.: 9873812005

]]>