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