| Author |
Topic |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2010-05-03 : 15:59:06
|
| Hi,I am using sql server 2005 Express Edition.In sql server management studio, when i try to connect to a server, i am not allowed to login. The sqlserver service is stopped and this is the reason for login failure.I am planning to uninstall the server and reinstall it.My question now is how to take a backup. Can i just copy the .mdf and .ldf files under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data ?Thanks in Advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2010-05-03 : 17:35:30
|
| Hi tkizer, When i checked the services, sql server express is not running. It is stopped.When i tried to restart it, i am getting the following error:Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.There were 3 different solutions posted at this link:http://www.tomrafteryit.net/sql-server-2005-express-error-3417/But none of them worked for me.1) right click sqlserver under administrative tools -> services and click properties and click on lgon tab and select local and the check box below.This did not work2) Problem may be due to compressed files in mssql->data . I checked here and the files were not compressed.3) Some one suggested to run the sqldiag.exe under 90->tools->Binn-> SQLDiag.exeNone of these worked for me.Any idea why i am not able to start the service?I also checked the permissions for the user. The user has required permissions.About reposting: sorry about that.I did not see my post so, i reposted it earlier.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2010-05-03 : 17:43:20
|
| Hi Tkizer,The event log that you mentioned , how can i access it?From the mangement studio, i cannot access it as i cannot log into it.Any other way to getit?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2010-05-05 : 15:40:37
|
| Hi tkizer,This issue was see on one of the test systems which i do not have access to and so the delay.I found these 2 Event ID's in the event viewer.Event ID: 3417 Cannot recover master database. Sql Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server books online.Event ID: 9003The Log scan number (225:376:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).If this error occurred during replication, recreate the publication.Otherwise, restore from backup if the problem results in a failure during startup.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2010-05-05 : 16:08:07
|
| Hi tkizer,This is a test system which we placed at one of our client places to test our software.I am not sure how fequently they used the software. They definitely have some data in it(in the range of 200 - 500 records)I am not sure if they have backups or not.Is there any way to recover the data? If not, i will uninstall the whole thing and reinstall it.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2010-05-05 : 16:21:05
|
| ok. Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
sql server backup