Viewing 15 posts - 7,201 through 7,215 (of 9,244 total)
i noticed issues with MDW while testing 2008, i personally wouldn't touch it at present
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 10:24 am
i would restore the full backup weekly and restore the diffs daily. Restore the logs in the event of a DR switch (minimal work).
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2011 at 1:42 pm
Brandie Tarvin (3/29/2011)
but MSDTC is running as a clustered resource
yes but the MSDTC group is only active on the one node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 12:49 pm
Brookstone (3/29/2011)
2003 standard and 4GB on the machine
the only option you have here is the use of the /3GB switch in the boot.ini
AWE support is for memory over 4GB which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 12:38 pm
RamSteve (3/29/2011)
Can some one shade some light by giving step by step to configure this process of log shipping with one primary and two secondary servers?Thanks in advance
It's wizard...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 12:33 pm
How much RAM do you have on the server?
Which edition of server 2003 do you have?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 12:30 pm
Brandie Tarvin (3/29/2011)
DTC is on the first active node with an instance. But just in case, what are these issues you are referring to so I can research them?
This first...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 12:19 pm
there are known issues if the clustered DTC resource is not active on the same node as the clustered sql server instance. Windows 2008 clusters allow mulitple clustered DTC applications,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 10:00 am
do you have any SQL Server 2008 policies in force that may be disabling it after enabling
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 9:50 am
sqldba_icon (3/29/2011)
Thanks. I am not sure what you meant with your second comment "instance will go down is node is lost" wouldnt the sql engine failover to other node ?
Database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 9:42 am
create table structure only using
select * into <newtable> from <oldtable> where 0 = 1
will not create any keys, etc though only table definition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 5:34 am
IMHO log shipping is probably your easiest option here and built in to SQL Server, it's also fairly easy to manage. User disconnections should be minimal if you get the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 5:29 am
sqldba_icon (3/28/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 5:09 am
Shanlyva
have you checked the event logs for the cluster operations to see if there is anyhting obvious there. Are you sure the new disks are not part of an existing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 5:04 am
you could do, but the script above supplies a lot more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2011 at 5:00 am
Viewing 15 posts - 7,201 through 7,215 (of 9,244 total)