Answer Posted / gaurdas06

Four jobs will create :
1. Backup job - to take the backup of the logs
2. Copy job - to copy the logs to the destination/secondary server
3. Restore job - to restore logs on the target server and lastly
4. alert job - to send alert or report for any errors

Thnx

Andy

How to disconnect from a sql server using mssql_close()?

1026

---

How to Check if table exists in sql server?

1075

---

Where are SQL server users names and passwords are stored in sql server?

1200

---

What is query parameter in ssrs?

143

---

What is sql server 2000 work load governor?

978

---

How do I start sql server 2017?

889

---

What is difference between clustered index and non clustered index?

1030

---

Where to find ntwdblib.dll version 2000.80.194.0?

922

---

What are the differences between triggers and stored procedures?

992

---

what is a check constraint?

1040

---

How to enter unicode character string literals in ms sql server?

1019

---

What function does a database engine serve in the sql server?

988

---

What are various aggregate functions that are available?

918

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

885

---

What is the default port for SQL Server over a firewall?

1032

---