0

I have 10 databases on my SQL Server. We do an Automatic Full Backup every day at 00.00.

The issue is there are two databases out of the 10 that should not be backed up as these databases are currently not required by the management; but I have no idea how to remove these databases from the Automatic Full Backup.

I am not able to find any script or anything related to the backup. The only thing I was able to find is the Full Backup option on the SQL Agent. Also these backups are done by SQL Server. Please help me out in resolving this issue.

When I went to SQL Server Agent> Jobs> Full Backup I found the following:

Screenshot

I am not able to make it out what exactly is this. Are these backups or something else? The files generated by these jobs are consuming my drive space and these jobs are running on daily basis.

Paul White
  • 94,921
  • 30
  • 437
  • 687
user1196687
  • 11
  • 1
  • 1
  • 1

3 Answers3

9

Its easy using T-SQL.

I would suggest not to use Maiantenance plan. Instead go with a much flexible and widely adapted TSQL based solution - SQL Server Backup by Ola Hallengren 

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES, -DB1,DB2', -- All user databases, except Db1, DB2
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Verify = 'Y',
@Compress = 'Y',
@CheckSum = 'Y',
@CleanupTime = 24
Community
  • 1
Kin Shah
  • 62,545
  • 6
  • 124
  • 245
1

I would check the Management > Maintenance Plans folder, in the Object Explorer pane of SSMS.

The other place would be under SQL Server Agent > Jobs, so I'm curious what you meant by, "I was able to find the full backup option on the SQL Agent." If there is a job titled "Full Backup" under the Jobs folder, then that's probably what you're looking for.

SQLDuck
  • 11
  • 3
1

This seems to me like the opposite of a problem... Regardless of requirements, I just feel better knowing every database is being backed up. Unless these two databases are quite large and can fill up a significant amount of disk space with backups, what negatives are there to backing up those files?

Luke Pafford
  • 311
  • 1
  • 11