Ask a Question

Categories

• All
• Computer Science & Engineering
• Information Technology
• Electronics & Communication
• Electrical Engineering
• Instrumentation (AEIE)
• Mechanical Engineering
• Civil Engineering
• MBA
• MCA
• BCA

what is the importance of system databases(master,model,MSDB,TEMPDB) with respect to sql server? what is the importance of database snapshot?

subhadip

on 2011-08-27 09:30:00  

the critical entities which are used to run the sql server are embeeded in system database .

subhadip

on 2011-08-27 09:30:00  

the database snapshot can give u the current situation or the current state of your database