Viewing 15 posts - 7,111 through 7,125 (of 9,244 total)
bill 36362 (5/19/2011)
I am upgrading RAM from 4GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 3:56 pm
they're just warnings and can be ignored providing you do not intend to install SSRS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2011 at 4:01 am
why not just use log shipping for the report databases, no need for snapshots or mirroring then?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2011 at 3:54 am
Viewing 15 posts - 7,111 through 7,125 (of 9,244 total)