Prev: Cascading deletion
Next: SQL Server 2000 Virtual_Device question
From: Jason Huang on 15 Dec 2009 20:27
Hi,

My SQL Server 2000 is on my Win2003 Server.
The SQL Server 2000's Maintenance Plan has backup job, which is exactly the
same time as the Win2003 Server file Backup schedule.
Will that be a problem?
Thanks for help.


Jason


From: Uri Dimant on 16 Dec 2009 04:23
Jason
Generally should not be a problem but why do you have them at the same time?


"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uWkl$7efKHA.4112(a)TK2MSFTNGP06.phx.gbl...
> Hi,
>
> My SQL Server 2000 is on my Win2003 Server.
> The SQL Server 2000's Maintenance Plan has backup job, which is exactly
> the same time as the Win2003 Server file Backup schedule.
> Will that be a problem?
> Thanks for help.
>
>
> Jason
>


From: Andrew J. Kelly on 16 Dec 2009 09:20
You may have some performance issues since you will be doing two resource
intensive operations at the same time but technically they should work. I
would highly recommend you switch one of the schedules so they don't execute
at the same time if possible.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uWkl$7efKHA.4112(a)TK2MSFTNGP06.phx.gbl...
> Hi,
>
> My SQL Server 2000 is on my Win2003 Server.
> The SQL Server 2000's Maintenance Plan has backup job, which is exactly
> the same time as the Win2003 Server file Backup schedule.
> Will that be a problem?
> Thanks for help.
>
>
> Jason
>
From: Tibor Karaszi on 16 Dec 2009 12:16
In addition to the other posts:

There could be problems, if you are writing to a backup file from SQL Server
while the file backup process is executing. I doubt this surpses you, and
depending on circumstances, this can be another resason to separate times.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uWkl$7efKHA.4112(a)TK2MSFTNGP06.phx.gbl...
> Hi,
>
> My SQL Server 2000 is on my Win2003 Server.
> The SQL Server 2000's Maintenance Plan has backup job, which is exactly
> the same time as the Win2003 Server file Backup schedule.
> Will that be a problem?
> Thanks for help.
>
>
> Jason
>
 | 
Pages: 1
Prev: Cascading deletion
Next: SQL Server 2000 Virtual_Device question