You may also want to copy the master files for later analysis. You can skip tempdb but make sure to get model and msdb. You could have a hardware or disk problem that could end up corrupting a new master database.Before you do anything else, stop the SQL Server service and make file copies of all your user database MDF and LDF files to another server. ,master database is corrupted, so I can't even login to sql server then how am i supposed to take the backups ?that is the reason i was thinking about replacing the master database from other server.ĭid you check the Windows Application log? My point is to get some kind of information as to what happened before you make permanent changes. How do you know master is corrupted? Did you run DBCC CHECKDB? What was the output?īut the problem is. How to back up a database: to restore master: (there are additional links inside)And you didn't answer my question about what kind of corruption you had. How to backup or restore master ? do you have any link or tutorial that I can follow ?no i am not taking backup of master regularly, no backup plan For one thing, what kind of corruption did you encounter? Why aren't you restoring master from a backup? (You are backing up master regularly, right?) It's very likely that copying over files from another server will not fix your problem and could indeed make it worse. You'd have to stop the SQL Server service to copy over files.And what you're proposing is not a good idea either.
You cannot detach master as SQL Server cannot run at all unless master is available. My "master" database has been corrupted so what I am doing is, copying master database from other server and pasting it in my current server.When I try to copy the "master" database from my other server, it gives me error saying "sql server is still using the database" so i guess i need to detach the "master" database first but i don't see any option in the "task" to detach the master database ?please help ?
We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 kommentar(er)
