Viewing 15 posts - 7,111 through 7,125 (of 9,241 total)
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
remember that when deploying multiple clustered instances of SQL Server that they all require their own unique resources for
disk
IP Address
Network name
You do not use the same network for multiple clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2011 at 3:51 am
Elliott Whitlow (5/16/2011)
1. SQL 2008 and SQL 2008R2 Standard Edition WILL install on a cluster that contains more than 2 nodes.
2. SQL 2008 and SQL 2008R2 Standard Edition setup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2011 at 12:27 pm
I found a webserver connecting to a back end database using SQL Server authentication, whereby the account used in the web site config file was the SA account. When i...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2011 at 1:49 am
Viewing 15 posts - 7,111 through 7,125 (of 9,241 total)