in that scenario yes

Lynn Pettis (2/12/2009)

---

if you had to restore from the previous day without using the end of day backup...

Barkingdog (2/12/2009)

---

When I use sql 2005 Management Studo to list the database servers are my company it returns a list containing servers with MSDE, Sql Server Express, Sql 2005, and...

sql2000 and sql2005 will co exist quite happily

first question is does the hardware support 64 bit platforms?

if yes then you would need to move all objects (databases, logins, etc) out of the cluster to a temporary sql...

wasnt there an issue with maintenance plans not cleaning up?

what version sql server do you have?

to get your version use

select serverproperty('productversion')

what security context is the agent running under?

local system, domain account, local user, etc

its not too much of a problem because a backup runs immediately after, but still not recommended.

scripts are easier to push out...

six if you count the private NIC ip address too

i would drop the statistics in the source (sql2000) database. As Gail said they will be re created if needed (assuming you have auto create statistics enabled on the database).

you...

kotlas

have you read the links Steve supplied?

scripted backup\maintenance jobs are your best option. Maintenance plans are becoming legacy.

why truncate the log before the backup? What is the recovery model of the database?

when rebuilding online simply specify sort_in_tempdb on or off. If a sort is required and you use tempdb just ensure that the location of tempdb has enough space

what version of SQL2005 are you using?

default fill factor if not changed is 0 which means 100%

DROP STATISTICS statisticsname

you can list more than one just separate them with a comma