Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arie01
Starting Member
8 Posts |
 Posted - 2011-08-23 : 14:30:59
|
| Hello, I'm new to SQL servers and I need a little help.I created a backup task by right-clicking the database I want to back up. I also created a maintenance plan to back it up. I noticed that the file produced by the maintenance plan is about 14 times smaller than the file produced by the back up task.First, which backup is supposed to be more complete?Second, how to I completely remove the backup task?Thank you kindly,Arie |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-23 : 16:58:22
|
| "I noticed that the file produced by the maintenance plan is about 14 times smaller than the file produced by the back up task"Is it a Log backup, or a Differential Backup, rather than a Full backup perhaps? |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-24 : 03:11:23
|
| You may have selected the option to compress backups in maintenance plan.PBUH |
|
|
|
arie01
Starting Member
8 Posts |
Posted - 2011-08-24 : 08:21:23
|
| Hi and thank you for replying to my post.In both cases, it supposed to be a full backup and if I'm not mistaken, in both cases compression is also selected.In any case, I'd like to completely remove the Back up task. How do I do that?Thank you again, |
|
|
|
|
|
|
Remove a backup job