Tuesday, March 27, 2012

Few questions

Hi All,
I am new in SQL SERVER 2000.I have few questions -
1) WHAT WILL I DO TO TRUNCATE THE SIZE OF A TRANSACTION LOG?
2) WHAT WILL BE THE STEPS OF BUILDING THE MASTER DATABASE?
3) WHAT WOULD BE THE PLAN OF ACTION WHEN SQL DOES NOT STARTS UP?
4) WHAT WOULD BE MY PLAN OF ACTION WHEN SQL DB GETS CORUPTED OR STARTS IN A SUSPECT MODE?1) See BACKUP
2) Install SQL 2000
3) Start MS-SQL, then examine the log file (whether it actually starts or not).
4) Determine what caused the problem(s), and fix it.

If these answers seem terse, it is because the questions sound like homework to me.

-PatP

No comments:

Post a Comment