Omit Database from Backup

Let me first say that I am new to SQL so please be patient with me. I have a
test database on my SQL server that I do not wish to backup. Is there a way
to omit this database from my daily backup? I can't find an option that shows
which databases are getting backed up just and option to backup local server
or multiple servers. Thanks,
Carl
You need to tell us where you run this backup (what tool you are using).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:A5A9CC15-1C8B-4369-B6CD-C6D8E5E6F069@.microsoft.com...
> Let me first say that I am new to SQL so please be patient with me. I have a
> test database on my SQL server that I do not wish to backup. Is there a way
> to omit this database from my daily backup? I can't find an option that shows
> which databases are getting backed up just and option to backup local server
> or multiple servers. Thanks,
> Carl
|||Sorry, I am running SQL 2005 and I am using SQL Server Agent to back up the
database to a file. Then every night my backup software backs up the data and
transaction files that are created by SQL.
"Tibor Karaszi" wrote:

> You need to tell us where you run this backup (what tool you are using).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Carl" <Carl@.discussions.microsoft.com> wrote in message
> news:A5A9CC15-1C8B-4369-B6CD-C6D8E5E6F069@.microsoft.com...
>
|||> Sorry, I am running SQL 2005 and I am using SQL Server Agent to back up
> the
> database to a file.
What does that mean? Do you have a BACKUP DATABASE command in the step of
the job? Or are you using a maintenance plan?

> Then every night my backup software
What is "my backup software"?
|||Yes I am using a maintenance plan. I have 3 database one that is the old one
that we converted from to our new custom program, the live database and a
test database. I only want to backup the live database not the other two. I
have a maintenance plan that I am running every night at 7pm. This backup job
is under the Server Management Studio under the SQL Server Agent. On the
properties of the backup job there is a section called targets. The only
choice is Target local server. In the properties I don't see a place where I
can choose which database I am backing up. I figure it is backing up all
three but I am not sure, this is the information that I am trying to find
out.
"Aaron Bertrand [SQL Server MVP]" wrote:

> What does that mean? Do you have a BACKUP DATABASE command in the step of
> the job? Or are you using a maintenance plan?
>
> What is "my backup software"?
>
>
|||Thanks for the help but I have figured it out. I went under the management
folder then maintenance plans and then backup and found the settings that I
was looking for under the properties of the backup.
"Aaron Bertrand [SQL Server MVP]" wrote:

> What does that mean? Do you have a BACKUP DATABASE command in the step of
> the job? Or are you using a maintenance plan?
>
> What is "my backup software"?
>
>
sql