Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Omit Database from Backup
0 views
Skip to first unread message
Carl
Jun 14, 2007, 11:02:00 AM6/14/07
to
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,
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
Tibor Karaszi
Jun 14, 2007, 12:37:24 PM6/14/07
to
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" <Ca...@discussions.microsoft.com> wrote in message
news:A5A9CC15-1C8B-4369...@microsoft.com...
Carl
Jun 14, 2007, 3:14:00 PM6/14/07
to
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.
database to a file. Then every night my backup software backs up the data and
transaction files that are created by SQL.
Aaron Bertrand [SQL Server MVP]
Jun 14, 2007, 3:17:19 PM6/14/07
to
> Sorry, I am running SQL 2005 and I am using SQL Server Agent to back up
> the
> database to a file.
> 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"?
Carl
Jun 14, 2007, 4:18:00 PM6/14/07
to
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.
folder then maintenance plans and then backup and found the settings that I
was looking for under the properties of the backup.
Carl
Jun 14, 2007, 4:17:03 PM6/14/07
to
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.
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:
0 new messages