April 16, 2002 at 3:08 pm
I get the same error as in the previous post. When I try to back up the TLOGs in my mintenance plan. I know that I can go to the Maintenance Job History to view exactly which part fails and the part that fails seems to be on the following databases
Northwinds (Which I dont know why I keep)
Pubs
master
distribution (I'm doing replication stuff)
msdb
These are pretty "still" databases could that be why the TLogs wont run because no changes have been made?
Need help Please advise
"I don't know what tomorrow holds
but I know who holds tomorrow."
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 16, 2002 at 5:59 pm
Sorry, lots of post here, which error. Also did you make a full backup of these databases before the TL backup? Also why are you doing TL backups on Northwind and Pubs, these should not normally be in a TL backup?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 16, 2002 at 6:03 pm
Doubly sorry, found the other. Here is what I posted
Check these out on the MS KB site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=Error%252022029&Queryc=Error+22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25
But I almost bet it is the master backup that is your base issue. (possible may be not allowed on the others.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 17, 2002 at 7:54 am
I really have no idea why they keep these databases at all. What is the effect of deleting them?
Yes, a Full backup is being done before it attempts the TLog. I was assuming that the TLog was failing on the Northwinds and Pubs DB because it receives no transactions but it also fails on the msdb and the distribution DB and those do receive transactions.
The maint jobs are set up like this:
MP1 does the system DB
MP2 does the User DBs
The master is on the maint plan w/ the system DB's Is that the problem?
"I don't know what tomorrow holds
but I know who holds tomorrow."
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 17, 2002 at 10:56 am
What is the effect of deleting them? They go away and you get extra drive space, sorry couldn't resist as all our production systems have dumped these (we do keep for testing).
What happens if you take master, distribution, model and msdb and do not do a TL backup. These really are you life source and I suggest do a full backup as opposed to TL (master cannot be done TL anyway, but some of the others may not allow and I just don't see this noted anywhere). Also how often are you doing TL backups?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 17, 2002 at 11:33 am
O.k. I will delete them. I guess they never bothered me that's why they were still there. I have read and done more research on the Error. My sites need to upgrade to SP2. That will fix some of the errors.
The Master, model, etc (System DB's) do get full backups. But I guess doing full only will be o.k. especially since I have them set up through the maint job. That makes it easier.
Also in my reading I found that if the
DB recovery is set to simple VS Full or Bulk logging that causes a problem.
My Tlogs run every 4 hours.
I think that now I have the situation under control.
Thanks for the help.
DBA Wanna B
"I don't know what tomorrow holds
but I know who holds tomorrow."
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 17, 2002 at 11:42 am
Let us know if this goes away or if you have any other issues. Also just so I don't cause you any issues myself inadvertently. You should always perform a full backup of master and msdb anytiem you make changes to DBs, Jobs, server settings or better yet just do periodically as often as possible. Don't catch yourself without a good backup of these.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 17, 2002 at 11:47 am
Never That.... We have been blessed in that area. I keeps backups :+D
"I don't know what tomorrow holds
but I know who holds tomorrow."
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 24, 2002 at 5:58 pm
quote:
I get the same error as in the previous post. When I try to back up the TLOGs in my mintenance plan. I know that I can go to the Maintenance Job History to view exactly which part fails and the part that fails seems to be on the following databasesNorthwinds (Which I dont know why I keep)
Pubs
master
distribution (I'm doing replication stuff)
msdb
These are pretty "still" databases could that be why the TLogs wont run because no changes have been made?
Need help Please advise
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 24, 2002 at 6:02 pm
quote:
I get the same error as in the previous post. When I try to back up the TLOGs in my mintenance plan. I know that I can go to the Maintenance Job History to view exactly which part fails and the part that fails seems to be on the following databasesNorthwinds (Which I dont know why I keep)
Pubs
master
distribution (I'm doing replication stuff)
msdb
These are pretty "still" databases could that be why the TLogs wont run because no changes have been made?
Need help Please advise
"I don't know what tomorrow holds
but I know who holds tomorrow."
Remove the "check database integrity" check. this should work on a full backup
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply