Instance Level Object Backup - by RobNicholson, MCSM

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


3
0
Sign in
to vote
ID 839687 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/23/2014 11:52:12 PM
Access Restriction Public

Description

It would be really nice if you could make something like an instance object backup. Every organisation I have worked for have done this differently eg scripting objects to a file, an Agent job that runs TSQL, using system db backups, SSIS packages, etc. I know some of these are valid workarounds but it would be nice to have something native and simple. In 2012 Contained Databases were introduced but they do not support all instance objects. Something that can backup logins, linked servers, Agent Jobs, policies, keys, server roles, credentials etc into one file. 

--by default maybe it could backup logins, agent jobs, linked servers, etc 
BACKUP INSTANCE_OBJECTS TO DISK = 'E:\sample.bak' 

--using WITH you could explicitly define what you'd like (maybe some people don't want their keys or credentials stored in the backup) 
BACKUP INSTANCE_OBJECTS TO DISK = 'E:\sample.bak' WITH LOGINS, AGENT_JOBS, LINKED_SERVERS

--example restore: if a login exists replace it 
RESTORE INSTANCE_OBJECTS FROM DISK = 'E:\sample.bak' WITH LOGINS, REPLACE 
Sign in to post a comment.
Posted by Microsoft on 4/17/2014 at 11:32 AM
Thank you for your suggestion.
This is not an area which we are investing in at this time, so I am closing this DCR as "won't fix".
This request is well understood, and may be implemented in the future if we are investing in the area.