Viewing 15 posts - 7,111 through 7,125 (of 9,244 total)
bill 36362 (5/19/2011)
I am upgrading RAM from 4GB...
May 19, 2011 at 3:56 pm
they're just warnings and can be ignored providing you do not intend to install SSRS
May 19, 2011 at 3:35 am
the ghost cleanup is designed to only delete small amounts of records at a time to avoid swamping the DE performance. With lots of rows you may not see an...
May 19, 2011 at 3:25 am
Chrissy321 (5/18/2011)
I have a 'Operating system (CmdExec)' step set up with the following command.
bcp master.dbo.sp_help_revlogin out c:\test.txt -n -SMYSERVER\MYINSTANCE -T
I am...
May 19, 2011 at 2:36 am
melissa.dougherty (5/18/2011)
I had read suggestions about not using the FQN...
that's bad advice then
melissa.dougherty (5/18/2011)
I put an alias in the hosts file.
rely on DNS that what it is...
May 18, 2011 at 4:14 pm
Chrissy321 (5/18/2011)
Perry Whittle (5/18/2011)
I prefer BCP for my login exportsDoesn't BCP require xp_cmdshell to call it?
No it's an external SQL server executable. I use a SQL server agent job to...
May 18, 2011 at 4:05 pm
sounds like it could be NTFS\share permissions on the file path. The NTFS permissions may be correct but if setting up a new share and not modifying the share permissions...
May 18, 2011 at 10:16 am
Robert Davis (5/18/2011)
Because then you have to kick off users to be able to apply the latest tran log backup.
I personally think this is a small price to pay and...
May 18, 2011 at 10:02 am
melissa.dougherty (5/18/2011)
ALTER DATABASE SharePointDB
SET WITNESS = 'TCP://MirrorDB/SQLServerWitness:5033';
GO
I get the following error...
Msg 1449, Level 16, State 5, Line 1
ALTER DATABASE command failed due to...
May 18, 2011 at 9:54 am
coronaride
when using log shipping, all modifications to the secondary database must be applied first to the primary, including indexes, adding users, etc.
Replication would probably be a better option but this...
May 18, 2011 at 9:42 am
Barry
are you able to check the SQL Server logs on the instance you are trying to backup the databases on
May 18, 2011 at 9:28 am
j.jj (5/18/2011)
So you have 2 unique cluster name's?
You have unique network names!
j.jj (5/18/2011)
seperate disk resources that are accessable from all nodes,
Yes, otherwise how would failover occur
j.jj (5/18/2011)
May 18, 2011 at 5:57 am
do you know what, it's something i have never tried. If you set up a share and add this as a resource into a cluster group i wouldn't be tempted...
May 18, 2011 at 4:04 am
MysteryJimbo (5/13/2011)
Windows 2008 includes enhancements for geographically dispersed clusters and across subnets and requires no additional software.
IIRC Windows 2008 can but SQL Server as an application cannot, worth double checking
May 18, 2011 at 4:01 am
why not just use log shipping for the report databases, no need for snapshots or mirroring then?
May 18, 2011 at 3:54 am
Viewing 15 posts - 7,111 through 7,125 (of 9,244 total)