automatically restarting merge replication after time out

Hello,
every few days my merge replication fails due to a network problem and
subsequent time out. How can I trigger a replication restart automatically,
or at a certain time of day?
Bill,
you can change the workflow properties on your merge agent's job so that the
third step on completion goes to the first step.
Alternatively, you could avoid continuous replication and have the merge
agent run on a schedule.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Automatic update fails

I'm getting automatic updates to install for SQL Server 2005. I am
technically fairly savvy, but I didn't even know I HAD SQL installed!
The problem is that the automatic update won't install, and it gives me no
reason why... but after it fails it continues to show up as an update waiting
to be installed. (I have set my auto updates to let me decide when to
install.)
"SQL Server 2005 Express Edition Service Pack 2 (KB921896) failed to install."
That's all I get. How do I determine WHY it won't install, and then fix it?
AuthorCancerForTwo (AuthorCancerForTwo@.discussions.microsoft.com) writes:
> I'm getting automatic updates to install for SQL Server 2005. I am
> technically fairly savvy, but I didn't even know I HAD SQL installed!
> The problem is that the automatic update won't install, and it gives me
> no reason why... but after it fails it continues to show up as an update
> waiting to be installed. (I have set my auto updates to let me decide
> when to install.)
> "SQL Server 2005 Express Edition Service Pack 2 (KB921896) failed to
> install."
> That's all I get. How do I determine WHY it won't install, and then fix
> it?
The only suggestion I can give is to download the service pack, and run
the install manually to see what it barfs about.
Hm, well there might be logs in
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix or
corresponding. But since you did not even know that you had SQL Express
installed, that directory may be elsewhere.
You could also check in Services that you actually have an SQL Server
service.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Thank you, Erland... I went to the place you identified and there were some
logs there - I looked at the most recent log and, sure enough, there was the
reason that it failed... Windows Authorization failed. I can't imagine
why... I never used pirated or unauthorized software. But it did give me the
name of the product that uses SQL and, therefore, probably installed it
unbeknownst to me, so I will try to re-install that software.
I must say that I have had a lot of trouble with that product, and I'm going
to dump it as soon as possible... this situation is just another good reason
to do so.
Thank you for your help!
"Erland Sommarskog" wrote:

> AuthorCancerForTwo (AuthorCancerForTwo@.discussions.microsoft.com) writes:
> The only suggestion I can give is to download the service pack, and run
> the install manually to see what it barfs about.
> Hm, well there might be logs in
> C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix or
> corresponding. But since you did not even know that you had SQL Express
> installed, that directory may be elsewhere.
> You could also check in Services that you actually have an SQL Server
> service.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

automatic dbase backup fails

Hi just wondering if anyone has any ideas what would cause an automatic
backup to fail when the manual backup works fine? There seems to be plenty
of disk space. Also there does not to be a log created showing any error
messages when the backup fails. The autobackup was setup in Enterprise
manager under Management/jobs. Also the SQL Server Agent is running. Thanks.
Paul G
Software engineer.
Is the backup being sent to a remote share or machine? If so make sure the
account SQL Server is running under has the proper rights to that share.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> Hi just wondering if anyone has any ideas what would cause an automatic
> backup to fail when the manual backup works fine? There seems to be
> plenty
> of disk space. Also there does not to be a log created showing any error
> messages when the backup fails. The autobackup was setup in Enterprise
> manager under Management/jobs. Also the SQL Server Agent is running.
> Thanks.
> --
> Paul G
> Software engineer.
|||the backup should be just going to the same machine as the database in the
directory c:\program files\microsoft sql server\BACKUP, thanks for the
information will check out the rights/permissions.
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Is the backup being sent to a remote share or machine? If so make sure the
> account SQL Server is running under has the proper rights to that share.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
>
>
|||Backing up to the same drive the database is on is a bad idea. If you loose
the drive you loose both the db and the backups. Have a look in the SQL
Error logs and in the job history and see if there is more info to go on.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...[vbcol=seagreen]
> the backup should be just going to the same machine as the database in the
> directory c:\program files\microsoft sql server\BACKUP, thanks for the
> information will check out the rights/permissions.
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
|||ok thanks for the additional information. We have a seperate backup of the
drive that occures daily but will probably back up to an external device in
the near future.
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Backing up to the same drive the database is on is a bad idea. If you loose
> the drive you loose both the db and the backups. Have a look in the SQL
> Error logs and in the job history and see if there is more info to go on.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...
>
>

automatic dbase backup fails

Hi just wondering if anyone has any ideas what would cause an automatic
backup to fail when the manual backup works fine? There seems to be plenty
of disk space. Also there does not to be a log created showing any error
messages when the backup fails. The autobackup was setup in Enterprise
manager under Management/jobs. Also the SQL Server Agent is running. Thanks.
--
Paul G
Software engineer.Is the backup being sent to a remote share or machine? If so make sure the
account SQL Server is running under has the proper rights to that share.
--
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> Hi just wondering if anyone has any ideas what would cause an automatic
> backup to fail when the manual backup works fine? There seems to be
> plenty
> of disk space. Also there does not to be a log created showing any error
> messages when the backup fails. The autobackup was setup in Enterprise
> manager under Management/jobs. Also the SQL Server Agent is running.
> Thanks.
> --
> Paul G
> Software engineer.|||the backup should be just going to the same machine as the database in the
directory c:\program files\microsoft sql server\BACKUP, thanks for the
information will check out the rights/permissions.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:
> Is the backup being sent to a remote share or machine? If so make sure the
> account SQL Server is running under has the proper rights to that share.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> > Hi just wondering if anyone has any ideas what would cause an automatic
> > backup to fail when the manual backup works fine? There seems to be
> > plenty
> > of disk space. Also there does not to be a log created showing any error
> > messages when the backup fails. The autobackup was setup in Enterprise
> > manager under Management/jobs. Also the SQL Server Agent is running.
> > Thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Backing up to the same drive the database is on is a bad idea. If you loose
the drive you loose both the db and the backups. Have a look in the SQL
Error logs and in the job history and see if there is more info to go on.
--
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...
> the backup should be just going to the same machine as the database in the
> directory c:\program files\microsoft sql server\BACKUP, thanks for the
> information will check out the rights/permissions.
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>> Is the backup being sent to a remote share or machine? If so make sure
>> the
>> account SQL Server is running under has the proper rights to that share.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
>> > Hi just wondering if anyone has any ideas what would cause an automatic
>> > backup to fail when the manual backup works fine? There seems to be
>> > plenty
>> > of disk space. Also there does not to be a log created showing any
>> > error
>> > messages when the backup fails. The autobackup was setup in Enterprise
>> > manager under Management/jobs. Also the SQL Server Agent is running.
>> > Thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||ok thanks for the additional information. We have a seperate backup of the
drive that occures daily but will probably back up to an external device in
the near future.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:
> Backing up to the same drive the database is on is a bad idea. If you loose
> the drive you loose both the db and the backups. Have a look in the SQL
> Error logs and in the job history and see if there is more info to go on.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...
> > the backup should be just going to the same machine as the database in the
> > directory c:\program files\microsoft sql server\BACKUP, thanks for the
> > information will check out the rights/permissions.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Is the backup being sent to a remote share or machine? If so make sure
> >> the
> >> account SQL Server is running under has the proper rights to that share.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> >> > Hi just wondering if anyone has any ideas what would cause an automatic
> >> > backup to fail when the manual backup works fine? There seems to be
> >> > plenty
> >> > of disk space. Also there does not to be a log created showing any
> >> > error
> >> > messages when the backup fails. The autobackup was setup in Enterprise
> >> > manager under Management/jobs. Also the SQL Server Agent is running.
> >> > Thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>

automatic dbase backup fails

Hi just wondering if anyone has any ideas what would cause an automatic
backup to fail when the manual backup works fine? There seems to be plenty
of disk space. Also there does not to be a log created showing any error
messages when the backup fails. The autobackup was setup in Enterprise
manager under Management/jobs. Also the SQL Server Agent is running. Thank
s.
--
Paul G
Software engineer.Is the backup being sent to a remote share or machine? If so make sure the
account SQL Server is running under has the proper rights to that share.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> Hi just wondering if anyone has any ideas what would cause an automatic
> backup to fail when the manual backup works fine? There seems to be
> plenty
> of disk space. Also there does not to be a log created showing any error
> messages when the backup fails. The autobackup was setup in Enterprise
> manager under Management/jobs. Also the SQL Server Agent is running.
> Thanks.
> --
> Paul G
> Software engineer.|||the backup should be just going to the same machine as the database in the
directory c:\program files\microsoft sql server\BACKUP, thanks for the
information will check out the rights/permissions.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Is the backup being sent to a remote share or machine? If so make sure th
e
> account SQL Server is running under has the proper rights to that share.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
>
>|||Backing up to the same drive the database is on is a bad idea. If you loose
the drive you loose both the db and the backups. Have a look in the SQL
Error logs and in the job history and see if there is more info to go on.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...[vbcol=seagreen]
> the backup should be just going to the same machine as the database in the
> directory c:\program files\microsoft sql server\BACKUP, thanks for the
> information will check out the rights/permissions.
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>|||ok thanks for the additional information. We have a seperate backup of the
drive that occures daily but will probably back up to an external device in
the near future.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Backing up to the same drive the database is on is a bad idea. If you loo
se
> the drive you loose both the db and the backups. Have a look in the SQL
> Error logs and in the job history and see if there is more info to go on.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...
>
>