Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 28 June 2016

Deprecated Feature in SQL Server? Why do we deprecated feature in Backup Log with No_LOG or With Truncate_only what is the replacement?

Deprecated Feature in SQL Server? Why do we deprecated feature in Backup Log with No_LOG or With Truncate_only what is the replacement?

Ref:
https://taiwanbeef.wordpress.com/2008/03/09/this-feature-will-be-removed-in-a-future-version-of-microsoft-sql-server-升級時又要改sql語法/

Category Deprecated feature Replacement
Backup and restore DUMP statement BACKUP
Backup and restore LOAD statement RESTORE
Backup and restore BACKUP LOG WITH NO_LOG None.The transaction log is automatically truncated when the database is using the simple recovery model. If you need to remove the log backup chain from a database, switch to the simple recovery model.
Backup and restore BACKUP LOG WITH TRUNCATE_ONLY None.The transaction log is automatically truncated when the database is using the simple recovery model. If you need to remove the log backup chain from a database, switch to the simple recovery model.
Backup and restore BACKUP TRANSACTION BACKUP LOG
Backup and restore BACKUP { DATABASE | LOG } WITH PASSWORD None.
Backup and restore BACKUP { DATABASE | LOG } WITH MEDIAPASSWORD None.
Backup and Restore RESTORE { DATABASE | LOG } … WITH DBO_ONLY RESTORE { DATABASE | LOG } … … WITH RESTRICTED_USER
Backup and restore RESTORE { DATABASE | LOG } WITH PASSWORD None.
Backup and restore RESTORE { DATABASE | LOG } WITH MEDIAPASSWORD None.
Compatibility levels 60 and 65 compatibility levels None.
Compatibility levels 70 compatibility level None.
DBCC DBCC CONCURRENCYVIOLATION None.
Extended stored procedure programming srv_getuserdatasrv_setuserdata Use CLR Integration instead.
Full-text search sp_fulltext_service action values clean_up, connect_timeout, and data_timeout return zero. None.
Instance options SET REMOTE_PROC_TRANSACTIONSsp_configure remote proc trans Use linked servers and distributed queries.sp_addlinkedserver
Remote servers Use of remote serverssp_addserver to create remote servers Use linked servers.sp_addlinkedserver to create linked servers
Security sp_addaliassp_dropalias sp_addgroup
sp_changegroup
sp_dropgroup
sp_helpgroup
Superseded by roles
Security SETUSER EXECUTE AS
System tables syssegments None.