How to create maintenance plan that will backup all databases Full backup in SQL Server

preview_player
Показать описание
In this video you will answer SQL Server DBA interview Question "You need to create full backup of all the databases from one of the SQL Server Instance every night. If any new database is created that should also become the part of backup process. What would be your approach to perform this?"

Complete list of SQL Server DBA Interview Questions by Tech Brothers
Рекомендации по теме
Комментарии
Автор

Hi, Thank you for the video. In a situation where i need to backup to different locations. Can i do it using the maintenance plan wizard or it must be Tsql

elijahabolaji