Skip to content

ReadMe_static.md

Latest commit

 

History

History
38 lines (25 loc) · 2.92 KB

ReadMe_static.md

File metadata and controls

38 lines (25 loc) · 2.92 KB

MS-SQL

IDE

Plugins

  • MySQL
  • PostgreSQL
  • SandDance for Azure Data Studio
  • SQL Database Projects
  • SQL Server Schema Compare
  • Visual Studio IntelliCode

Backup

  • COMPRESSION : Explicitly enables backup compression.
  • FORMAT Specifies that a new media set be created.
  • MEDIANAME : Specifies the media name for the entire backup media set
  • NORECOVERY : Backs up the tail of the log and leaves the database in the RESTORING state
  • STATS : Displays a message each time another percentage completes, and is used to gauge progress

Restore

  • FILE : Names a file to include in the database restore.
  • NOUNLOAD : Specifies that after the RESTORE operation the tape remains loaded on the tape drive.
  • STATS : Displays a message each time another percentage completes, and is used to gauge progress

Blogs

Upgrade Considerations

If you restore a SQL Server 2005 (9.x) or higher database to SQL Server, the database is automatically upgraded.