• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:


By any chance do you know about how SQL server is going to change the local backups. I know that they are dropping support for Tape backup.
This will be bad for Network admins who are using tape backups.

Is there any other change for local backups in SQL server?

I might be misinterpreting it and Not sure how much of this is true but......

See this link:

The following support limitations and considerations are specific to SQL Server 2016:
  • Microsoft Azure Blob Storage service is the only supported backup storage option. Backups to disk or tape are not supported.

But on MS documentation I can see this link. This mentions the steps to backup the DB to Disk/Tape:

Then in this MS documentation they mention something else:

  • Support for tape backup devices will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Its a bit confusing.

Any ideas guys ????
  • 2
  • 2
1 Solution
ManjuIT - Project ManagerCommented:
Tape backup does exist in SQL 2016, however Microsoft did mention that it will be removed in its future versions. Currently not sure if it'll be removed from next or when...

Microsoft site : https://msdn.microsoft.com/en-us/library/ms191209.aspx
ArikkanAuthor Commented:
Yes. That's what I am confused about. Also do you know if disk backup will be affected in any way?
ManjuIT - Project ManagerCommented:
At this point in time, there's no clear inputs from microsoft about disk backups.., Per comments from MS, it will only impact tape back up in their future versions. We simply have to wait for more updates from MS.
ArikkanAuthor Commented:
Dhanyawaad bhratashri :-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now