Answer / santhosh

In a Command Prompt window, you can start the SQL server in
minimal configuration mode by typing: sqlservr -c -f

This command also starts the SQL server in single-user mode.
Also, the server will not run any startup stored procedures.
Additionally, when you start the SQL server in minimum
configuration mode, then SQL Server automatically sets the
size of tempdb to 2 MB on its default device. You must then
manually increase the size of tempdb as necessary.

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

what is the use of home directory???

1 Answers   HP,

---