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語法/
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. |
No comments:
Post a Comment