Viewing 15 posts - 4,351 through 4,365 (of 9,253 total)
SQLCrazyCertified (2/1/2013)
DECLARE fixusers CURSORFOR
SELECT UserName = name FROM sysusers
WHERE issqluser = 1 AND (sid IS NOT NULL AND sid <> 0x0)
This first part declares a cursor checking sql server...
February 1, 2013 at 12:17 pm
ratheesharc (2/1/2013)
Thank you anthony.green,Fulltext index already created the in developing server and want to implement in production server with changing the filegroup.
How do i change my full text file group.
On...
February 1, 2013 at 5:32 am
Koen Verbeeck (2/1/2013)
Also, if one of the disks crashes, you don't lose everything.
That's not entirely true.
If you have separate data and log drives and no backups and the data...
February 1, 2013 at 2:01 am
You need to create virtual machines and set up a cluster from there. See my guide at these links
February 1, 2013 at 1:44 am
LS does not provide a true read only standby whereas AO does, up to 4 of them in fact.
If you're not convinced that AO replaces LS read the MS...
January 31, 2013 at 11:00 pm
Is the SQL Server agent service running?
Open Failover Cluster manager and check the clustered service resource is healthy
January 31, 2013 at 9:16 am
SQLCrazyCertified (1/29/2013)
Hi, Thanks for both of your replies.I have fixed the issue by doing couple of more log backups then I shrank and it worked.
You have cycled the log back...
January 31, 2013 at 9:15 am
sdpages (1/29/2013)
I have a SQL log-shipping High availability setup from a Primary Server to a Secondary Server which ships transactional logs every 1 hour. Both the databases are running...
January 31, 2013 at 9:11 am
SQLCrazyCertified (1/28/2013)
I have a db with mirroing in place and log is growing about 49GB.....Log is growing since log backup not running as it scheduled. So, I manually...
January 29, 2013 at 4:07 am
anthony.green (1/29/2013)
January 29, 2013 at 4:03 am
anthony.green (1/28/2013)
A page is allocated to a table
or an index 😉
January 29, 2013 at 2:25 am
OPC is correct, XP_FIXEDDRIVES cannot enumerate mounted volumes. A straight WMI call will also work using
wmic volume get capacity, "free space", name
You can also supply an output file and...
January 29, 2013 at 2:24 am
I wasnt being sarcastic i'm genuinely surprised!
you're right, i dont think theres a good reason, AO replaces log shipping and mirroring and pretty much makes them redundant 😉
Leo.Miller (1/24/2013)
January 28, 2013 at 11:35 pm
Shouldn't you be actually gaining the required knowledge rather than brain dumping a few answers. No doubt if you do manage to land the role any support you require will...
January 28, 2013 at 5:10 am
Niyala (1/25/2013)
I can evict one and install the other widnows cluster.
No! Don't just evict the nodes.
Niyala (1/25/2013)
January 25, 2013 at 7:47 am
Viewing 15 posts - 4,351 through 4,365 (of 9,253 total)