Viewing 15 posts - 8,416 through 8,430 (of 9,241 total)
you could maybe limit the query
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 1:03 pm
Charles Kincaid (2/13/2009)
Perry Whittle (2/12/2009)
connect to each instance and executeselect serverproperty('edition'), serverproperty('productversion')
note the results down for each instance you connect to
That works great. I wonder if this works for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 11:48 am
gaganks (2/13/2009)
The version is --9.00.3068.00 (sp2)
Appericiate your support for few more suggestions
Thanks..
as far as i recall that version should be fine. Double check the delete task
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 11:43 am
in that scenario yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2009 at 2:34 am
Lynn Pettis (2/12/2009)
Truncating the log just before the full backup breaks the log chain.
if you had to restore from the previous day without using the end of day backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 4:43 pm
Barkingdog (2/12/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:50 pm
sql2000 and sql2005 will co exist quite happily
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:40 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:38 pm
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')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:33 pm
what security context is the agent running under?
local system, domain account, local user, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:23 pm
GSquared (2/12/2009)
Definitely don't truncate the log file.
its not too much of a problem because a backup runs immediately after, but still not recommended.
scripts are easier to push out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:19 pm
Jeffrey Williams (2/12/2009)
At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.
six if you count the private NIC ip address too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:04 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:45 pm
kotlas
have you read the links Steve supplied?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:28 pm
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:19 pm
Viewing 15 posts - 8,416 through 8,430 (of 9,241 total)