question

CarmineNatale-1407 avatar image
0 Votes"
CarmineNatale-1407 asked OlafHelper-2800 answered

backup non-database objects for disaster recovery

I need to backup the whole sql server instance for disaster recovery.
I can't find an easy way to do this for all non-database objects like linked servers, agent jobs, mail settings, maintenance plans, etc...

Do I have to create scripts for all non-db objects?

Thanks.

windows-server-backup
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

like linked servers, agent jobs, mail settings, maintenance plans, etc...

The informations are all stored in the system databases "master" and "msdb", so backup the system database in same way as your user databases.
See Backup & restore: system databases (SQL Server)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.