| Author |
OUR TRN LOGS ARE NOT BEING BUILT
|
|
| thejamie 2006-11-07, 7:12 pm |
| Error is:
Backup can not be performed on this database. This sub task is ignored
--
Regards,
Jamie
"thejamie" wrote:
> I see errors in my DB Maint log that indicates indexes are not being rebuilt.
> We are having production problems - time outs. Does the optimization plan
> for DB Maintenence drop bad indexes - simply put, what is my best way to
> handle back indexes on a production server?
>
> --
> Regards,
> Jamie
| |
| Tracy McKibben 2006-11-07, 7:12 pm |
| thejamie wrote:
> Error is:
> Backup can not be performed on this database. This sub task is ignored
That has nothing to do with indexes... This error is telling you that
you are attempting to do a transaction log backup against a database
that is in Simple recovery mode.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| thejamie 2006-11-07, 7:12 pm |
| That particular database is a production database. Why would it be in simple
recovery mode?
--
Regards,
Jamie
"Tracy McKibben" wrote:
> thejamie wrote:
>
> That has nothing to do with indexes... This error is telling you that
> you are attempting to do a transaction log backup against a database
> that is in Simple recovery mode.
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
| |
| Tracy McKibben 2006-11-07, 7:12 pm |
| thejamie wrote:
> That particular database is a production database. Why would it be in simple
> recovery mode?
Only you can answer that question...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| thejamie 2006-11-07, 7:12 pm |
| Can you give me a hint on this... it appears to be in normal mode - not
recovery mode.
--
Regards,
Jamie
"Tracy McKibben" wrote:
> thejamie wrote:
>
> Only you can answer that question...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
| |
|
| Open the database property window, select the option tab and check what
recovery mode your database on
vinu
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:2D4155FC-D55C-4C9C-9630- 1327B0E66D0B@microso
ft.com...[color=darkred]
> Can you give me a hint on this... it appears to be in normal mode - not
> recovery mode.
> --
> Regards,
> Jamie
>
>
> "Tracy McKibben" wrote:
>
| |
|
| Does your maintenance plan include master databases, if so remove it from ur
maintenance plan darabase list..
vinu
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:2D4155FC-D55C-4C9C-9630- 1327B0E66D0B@microso
ft.com...[color=darkred]
> Can you give me a hint on this... it appears to be in normal mode - not
> recovery mode.
> --
> Regards,
> Jamie
>
>
> "Tracy McKibben" wrote:
>
| |
| thejamie 2006-11-07, 7:12 pm |
| Thanks. I am in simple recovery mode. I would like to know I can run a
point in time restore. Do I need to switch to FULL recovery mode for this?
--
Regards,
Jamie
"vt" wrote:
> Does your maintenance plan include master databases, if so remove it from ur
> maintenance plan darabase list..
> vinu
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:2D4155FC-D55C-4C9C-9630- 1327B0E66D0B@microso
ft.com...
>
>
>
| |
|
| With simple recovery mode you will not be able to do point in time restore
read BOL (Book online) for more detail..
vinu
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:F1B75A04-D4AF-4F82-BBBE- 681891483C4B@microso
ft.com...[color=darkred]
> Thanks. I am in simple recovery mode. I would like to know I can run a
> point in time restore. Do I need to switch to FULL recovery mode for
> this?
> --
> Regards,
> Jamie
>
>
> "vt" wrote:
>
| |
| thejamie 2006-11-07, 7:12 pm |
| Yes. That's right. Will the server need anything more than a reboot to
enter full recovery mode?
--
Regards,
Jamie
"vt" wrote:
> With simple recovery mode you will not be able to do point in time restore
> read BOL (Book online) for more detail..
>
> vinu
>
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:F1B75A04-D4AF-4F82-BBBE- 681891483C4B@microso
ft.com...
>
>
>
| |
| Kalen Delaney 2006-11-07, 7:12 pm |
| Hi Jamie
You don't even need to reboot. Just change to FULL, then make a full db
backup.
From that point on, you will be able to make log backups, and use them to
restore to a specific point in time, when necessary.
Please read the documentation on log backups and recovery models.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:7A6C958E-1DBD-4E41-8361- 75FA5EE7996E@microso
ft.com...[color=darkred]
> Yes. That's right. Will the server need anything more than a reboot to
> enter full recovery mode?
> --
> Regards,
> Jamie
>
>
> "vt" wrote:
>
| |
|
| I don't think server will ask you to reboot
go ahead
vt
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:7A6C958E-1DBD-4E41-8361- 75FA5EE7996E@microso
ft.com...[color=darkred]
> Yes. That's right. Will the server need anything more than a reboot to
> enter full recovery mode?
> --
> Regards,
> Jamie
>
>
> "vt" wrote:
>
| |
| thejamie 2006-11-07, 7:12 pm |
| Thanks to all of you. This is a big load off my mind.
--
Regards,
Jamie
"vt" wrote:
> I don't think server will ask you to reboot
> go ahead
>
> vt
>
>
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:7A6C958E-1DBD-4E41-8361- 75FA5EE7996E@microso
ft.com...
>
>
>
| |
| Hulicat 2006-11-07, 7:12 pm |
| Run this in query analyzer:
alter database dbname
set recovery Full
No reboot required
thejamie wrote:[color=darkred
]
> Thanks to all of you. This is a big load off my mind.
> --
> Regards,
> Jamie
>
>
> "vt" wrote:
>
| |
| Greg D. Moore \(Strider\) 2006-11-07, 7:12 pm |
|
"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:D8A1EEBD-95A0-4DB4-B40A- AD3AD0EA4E22@microso
ft.com...
> Thanks to all of you. This is a big load off my mind.
Umm, not quite.
Make sure you do transaction log backups.
And keep in mind a disaster recovery plan is far more than simply "turning
on backups".
It's managing them among other things.
How many often will you take a full backup? How long will you keep it?
How often will you take transaction backups. How long will you keep them?
Etc.
[color=darkred]
> --
> Regards,
> Jamie
>
>
> "vt" wrote:
>
| |
| Kalen Delaney 2006-11-07, 7:12 pm |
| And what kind of testing will you do to make sure you can smoothly recover
from your backups when the need arises?
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Greg D. Moore (Strider)" < mooregr_deleteth1s@g
reenms.com> wrote in message
news:%23zodPZgAHHA.3836@TK2MSFTNGP02.phx.gbl...
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:D8A1EEBD-95A0-4DB4-B40A- AD3AD0EA4E22@microso
ft.com...
>
> Umm, not quite.
>
> Make sure you do transaction log backups.
>
> And keep in mind a disaster recovery plan is far more than simply "turning
> on backups".
>
> It's managing them among other things.
>
> How many often will you take a full backup? How long will you keep it?
>
> How often will you take transaction backups. How long will you keep them?
>
> Etc.
>
>
>
>
| |
| thejamie 2006-11-07, 7:12 pm |
| We're running simulations on virtual servers. Thanks again everyone for your
help.
--
Regards,
Jamie
"Kalen Delaney" wrote:
> And what kind of testing will you do to make sure you can smoothly recover
> from your backups when the need arises?
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
>
> "Greg D. Moore (Strider)" < mooregr_deleteth1s@g
reenms.com> wrote in message
> news:%23zodPZgAHHA.3836@TK2MSFTNGP02.phx.gbl...
>
>
>
| |
| Greg D. Moore \(Strider\) 2006-11-10, 7:14 pm |
|
"Kalen Delaney" < replies@public_newsg
roups.com> wrote in message
news:eEBNUqgAHHA.1220@TK2MSFTNGP04.phx.gbl...
> And what kind of testing will you do to make sure you can smoothly recover
> from your backups when the need arises?
>
Oh yeah. Good point. :-)
(We do home rolled log-shipping of most of our databases, which is a real
good check that backups are working etc. ;-)
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
>
> "Greg D. Moore (Strider)" < mooregr_deleteth1s@g
reenms.com> wrote in
> message news:%23zodPZgAHHA.3836@TK2MSFTNGP02.phx.gbl...
>
>
|
|
|
|