Re: Problem with Transaction backups

There are a lot of bugs related to the maintenance plans so make sure you are running the latest service pack (tested of course). You may need to drop and recreate the plan altogether if it doesn't save it by just editing it.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Help Me" <HelpMe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E6836821-51D4-4AF4-86C5-A68319786B75@xxxxxxxxxxxxxxxx
More info:

Basically we have an SQL server that was running full backups and hourly
transaction backups together. Then about a little over a month ago we found
this.
-> when you go into the backup plan (SQL Server 2005) and edit the database
list on the plan, the changes are not saved when you come back.
First I thought this was a user problem or an security problem so I created
a test database and tried the same thing and got the same results. we can't
add or change an existing backup plan for hourly transaction backups.

Our databases are running with a FULL recovery Mode. its SQL Server 2005.
And I'm logged in as Window's Administrator under mixed mode.

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00
(srv03_sp2_rtm.070216-1710)



"Andrew J. Kelly" wrote:

Are those dbs in simple recovery mode?

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Help Me" <Help Me@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47A81307-44E7-4E2A-B7A5-6823AA504D26@xxxxxxxxxxxxxxxx
> Recently on two of our servers, we noticed that the transaction logs > were
> not
> being processed hourly. When we looked we noticed that the database > names
> were not being saved in the edit window. We also noticed that the > option
> to
> show the SQL statement opened blank. when we sellected the same > databases
> again and reopened SQL, the settings were not being saved.
>
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.086.3959.00
> (srv03_sp2_rtm.070216-1710)
> Microsoft MSXML 2.6 3.0 4.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.1433
> Operating System 5.2.3790


.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: cant move sharepoint by the instructions. AGAIN
    ... Monitoring database to another location. ... If you installed the SQL Server or the SQL Server Management Tools, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: MS Access DAO -> ADO.NET Migration
    ... Microsoft chose to change the name from SQL Server Everywhere ... It's a fully relational database that supports a subset of the ... DAO has methods and properties that are Access ...
    (microsoft.public.dotnet.framework.adonet)
Quantcast