Viewing 15 posts - 3,466 through 3,480 (of 4,745 total)
you would have to un-install, re-install the SQL instance.
July 19, 2009 at 12:46 pm
The short answer is yes, those types of replication that use the transaction log will not truncate the log until transactions marked for replication are transferred to the distribution database.
It...
July 19, 2009 at 12:43 pm
In most cases no. BOL will tell you which options require a restart.
July 19, 2009 at 12:37 pm
Shane Osborne (7/19/2009)
OK so back to thelog shipping question, with the following 2 scenarios.
Unplanned failure - What happens when you bring the failed server back up ? What...
July 19, 2009 at 12:35 pm
Theres some discussion on this on the discussion thread for the mirroring QOTD from the 16th july
http://www.sqlservercentral.com/Forums/Topic753931-1598-1.aspx
July 19, 2009 at 11:24 am
database files not cleanly detached might not attach properly as the files might not be consistent.
I certainly would not feel comfortable relying on this as a DR method.
July 19, 2009 at 10:52 am
I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes UP and...
July 18, 2009 at 12:25 pm
A quick google search brings up this
process basically the same.
apply the SP to the active mode, use cluster admin if you want to stop SQL, run the SP from a...
July 18, 2009 at 11:25 am
yes, the service pack puts the SQL instance in single user mode as part of the upgrade as it is updating system catalogs.
Procedure:
Stop all connections to the databases(s), i.e turn...
July 17, 2009 at 3:51 pm
The last option which seems bad practice but could work is simply kill all users, detach db's and then reattach to other server. Any issues with this ?
going to...
July 17, 2009 at 3:30 pm
As your database files are on a SAN the option of SAN based replication may be available to you.
July 17, 2009 at 3:26 pm
thats good to know steve. I am sure I have seen threads on this site where people have said they are mirroring quiete high numbers of databases. I don't believe...
July 17, 2009 at 2:33 am
good timing steve, I was thinking about checking up on this very question this afternoon!
the article says 32bit system so I presume 32 bit SQL on a 64bit OS would...
July 16, 2009 at 7:18 am
We've got it deployed on 3 SQL clusters backing up over 7000 databases on a nightly basis.
quote]
7000? wow. I'm sold, now to convince the management and a client who wants...
July 11, 2009 at 7:31 am
sounds to me like the basic problem is the fact the sql server i/o is shared with i/o from other types of servers. the i/o patterns for SQL are radically...
July 10, 2009 at 5:20 am
Viewing 15 posts - 3,466 through 3,480 (of 4,745 total)