InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are Truncate Options Available In Sql Server? |
|
Answer» Use TRUNCATE_ONLY OPTION for SQL Server 2005 systems while performing Backup. This option is not AVAILABLE in SQL Sever 2008 and R2. INSTEAD, we use ON_TRUNCATE option available in the Backup statement. Use TRUNCATE_ONLY option for SQL Server 2005 systems while performing Backup. This option is not available in SQL Sever 2008 and R2. Instead, we use ON_TRUNCATE option available in the Backup statement. |
|