 | |
transaction logs back up through sql maintenance plan
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: transaction logs back up through sql maintenance plan -
12-06-2008
, 08:51 AM
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#32
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#33
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#34
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#35
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#36
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
#37
| |||
| |||
|
|
Sonia, every database has to be set to a Recovery Model. I believe Tibor mentions this and as he mentioned, if your database is set to SIMPLE Recovery Model, then Transaction Log of that database can not be backed up due to the nature of this Recovery Model. Have you checked History of your Maintenance Plan? If you can't find any useful info there, then check out the job' s history of this Maintenance Plan. -- Ekrem Önsoy "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:0598A9E6-73F0-47D7-8710-6D34A3CF76BF (AT) microsoft (DOT) com... Those databases are operational. So I believe they are not in recovery mode. "Tibor Karaszi" wrote: My guess is that at least one of the databases are in simple recovery model and the MPO stop when it encounters that db. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote in message news:55AE3DAD-407F-4544-BB6D-AA27A710C70D (AT) microsoft (DOT) com... I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs it only backs up transaction logs for three of them. When I checked in the backup database task window, I can see that all the six databases have been checked. I even recreated a new maintenance plan selecting all six databases again but it only backs up three database. However, I have another plan that makes a full back up for all the same six databases is working fine. I have been trying to figure out it since a couple of weeks but without any resolution. I will appreciate your any inputs. Sonia |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.