May 17, 2013 at 10:44 am
1. what type of pages are used in bulk log recovery model.
2. able to ping the server. but getting access denied error, what might be the reason
3. temp db is growing in size what might be the reason
4. what is open transaction
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
May 17, 2013 at 10:53 am
m.rajesh.uk (5/17/2013)
...
1. what type of pages are used in bulk log recovery model.
Same kind of pages used in Simple and Full recovery models. Transaction log doesn't use pages, uses log records. (Simplified answer, sure someone like Gail could provide a more detailed and accurate answer here.)
2. able to ping the server. but getting access denied error, what might be the reason
Would need to see the actual error message as well as when you are getting this message. Could be the server is up far enough that it can be seen on the network but hung coming up further to allow access to other services (been there, had it).
3. temp db is growing in size what might be the reason
Normal work on the server by SQL Server. Temporary tables, work tables, sorts, index rebuilds using tempdb, and probably numerous other activities.
4. what is open transaction
A transaction that has not been committed or rolled back.
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
Not sure, I haven't run into this issue (yet).
May 17, 2013 at 11:04 am
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
I don't think so. It's model database for all databases on the server including tempdb which is recreated every time server restarts. So, you will have problem recreating it if model db is corrupted.
To rectify it - just restore its latest backup.
May 20, 2013 at 3:35 am
can any one please answers the unanswered questions.
May 20, 2013 at 3:46 am
Why? Don't you like Lynn answers?
May 20, 2013 at 3:59 am
Lynns answers are great ... my intention is the last question is not been answered . So if any one knows answer for the last question .. i want to hear from them.
May 20, 2013 at 4:04 am
m.rajesh.uk (5/20/2013)
Lynns answers are great ... my intention is the last question is not been answered . So if any one knows answer for the last question .. i want to hear from them.
Didn't Eugene answer this? You could always delete your model database & try and start up SQL Server to see.
Dird
May 20, 2013 at 4:15 am
m.rajesh.uk (5/17/2013)
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2013 at 4:17 am
Eugene Elutin (5/17/2013)
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
I don't think so. It's model database for all databases on the server including tempdb which is recreated every time server restarts. So, you will have problem recreating it if model db is corrupted.
Depends on how bad the corruption is. If the corruption is encountered while SQL is trying to recover model, then SQL won't start
To rectify it - just restore its latest backup.
Works for corruption that doesn't affect SQL's ability to start. If SQL won't start because model's damaged, it's a little more complicated than just restoring.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2013 at 4:32 am
GilaMonster (5/20/2013)
Eugene Elutin (5/17/2013)
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
I don't think so. It's model database for all databases on the server including tempdb which is recreated every time server restarts. So, you will have problem recreating it if model db is corrupted.
Depends on how bad the corruption is. If the corruption is encountered while SQL is trying to recover model, then SQL won't start
To rectify it - just restore its latest backup.
Works for corruption that doesn't affect SQL's ability to start. If SQL won't start because model's damaged, it's a little more complicated than just restoring.
Yes. You are absolutely right. And your article is really great and can be used as To-Do-List-In-Case-Of...
Hopefully that for interview the short answer should be sufficient enough. Details could be clarified if interviewer would proceed with discussion...
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply