Open management studio >>connect to SQL Server>>Expand Management>>Right Click Maintenance plan>>Select New Maintenance Plan<\/p>\n
Give name as you like ( FullBackupDaily) it will open designer window.Left side you can see ToolBox tab.<\/p>\n
Select Backup Database task and double click or drag and drop it to designer pane.<\/p>\n
Edit the Task for options>> connection as local,Backup type as Full,Specify the Databases which u want to include for this backup.<\/p>\n
Provide valid path s backup directory (check backup integrity for best practice)<\/p>\n
2. just full backup –already covered in above steps<\/p>\n
3. full bak file should be with date, like testdb20110708.bak, testdb20110709.bak, consequently day by day.<\/p>\n
our plan will create backups as you expect,Now schedule it as per your requirement.<\/p>\n
to schedule please chek for ” subplan schedule” option.<\/p>\n
select frequency as daily ,time as 5 Am.<\/p>\n
4. just keep the recent 2 days bak files, like testdb20110708.bak and testdb20110709.bak<\/p>\n
We can use Maintenance cleanup task to achieve this<\/p>\n
drag and drop Maintenance cleanup task from ToolBox >>edit >>select backup files>>provide your backup files location>>file extension as Bak>>Check Delete files as ..>>Provide 2 days in Delete files older than following box.<\/p>\n
5. backup to a remote disk–already covered in above steps,but i recommend you to take backup into local drive first, later you can copy to remote disk if require.<\/p>\n
6. if could, how to fullfil differential and transactional log backup that will occurs every 24 hours and 1 hour respectitively?<\/p>\n
You can perform using same above steps but change backup type and schedule accordingly for each maintenance plan .<\/p>\n","protected":false},"excerpt":{"rendered":"
Open management studio >>connect to SQL Server>>Expand Management>>Right Click Maintenance plan>>Select New Maintenance Plan Give name as you like ( FullBackupDaily) it will open designer window.Left side you can see ToolBox tab. Select Backup Database task and double click or drag and drop it to designer pane. Edit the Task for options>> connection as local,Backup […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1838"}],"collection":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1838"}],"version-history":[{"count":0,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1838\/revisions"}],"wp:attachment":[{"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1838"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}