Job Roles

Can’t delete a row from primary table if there are related rows in secondary table.

Breaking of relationships is prevented once referential integrity on a database is enforced

They both are used to replace characters in a string

Multiple users can't share a local temporary table

Local :

Only available to the current Db connection for current user and are cleared when connection is closed.

Multiple users can’t share a local temporary table.

Global:

Available to any connection once created. They are cleared when the last connection is closed.

Can be shared by multiple user sessions

It is one of the operation of Log Shipping

Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server. This keeps the two SQL Server instances in sync with each other. In case production server fails, users simply need to be pointed to the standby/backup server. Log shipping primarily consists of 3 operations:

Backup transaction logs of the Production server.

Copy these logs on the standby/backup server.

Restore the log on standby/backup server.