Prev: 2 foreign keys point to the same primary key
Next: Backups sequence
From: Mr. Magic on 29 Jun 2010 07:48
Can you give me some direction with this? I've used perfmon some but not a
lot. And what should I be looking for?

"John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
news:ejbru5toik4a12cstj8v5imepacrv3lp5q(a)4ax.com...
> On Fri, 14 May 2010 08:51:49 -0400, "Mr. Magic" <Mufasa(a)NoWhere.Com>
> wrote:
>
>>I have a maintenance plan that backs up a database. The database is pretty
>>active all the time (it's a 24/7 app so there's no 'down' time). While the
>>backup is happening, the client apps get timeouts (the backup takes about
>>1-2 minutes to happen which is another question....).
>>
>>Is there something I can do so the client can still access the database
>>during the backup?
>>
>>TIA - Jeff.
>
>
> The database should be accessable, but there could be an issue with
> the resources available during the process. Have you looked at the
> perfmon counters?
>
> John

 | 
Pages: 1
Prev: 2 foreign keys point to the same primary key
Next: Backups sequence