Viewing 15 posts - 7,036 through 7,050 (of 9,241 total)
Sp_help_revlogin will script certain accounts that are unique to each machine, be sure to filter these out first.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2011 at 4:01 pm
Are you using the Microsoft iSCSI initiator?
IIRC MIcrosoft do not support or recommend teamed NICs for iSCSI,
You should be using the Multi Path IO component across multiple NICs for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2011 at 4:08 pm
Brandie Tarvin (6/22/2011)
Ah. That's a good point. I missed that.
So did I initially 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 8:19 am
It makes no difference!
Do you understand the difference between active\active and active\passive clusters?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 8:08 am
ok, if you understand the technologies then it is rather simple. Log shipping works the same whether on a cluster or a stand alone machine.
The only thing i would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 4:25 am
yes it is possible!
do you understand the 2 technologies as this is not something that can be detailed in a few lines of a forum post
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 2:55 am
i use a script that extracts the logins using BCP from the live server to a file, the file is then exported to the DR server and a script on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 2:42 am
joining the stand alone server to the domain will not cause any issues, although you may want to think about changing the SQL Server services to run under a domain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2011 at 2:36 am
the pictures arent really that helpful. You need to go into network sharing center and check adapter settings. In here hit the ALT key and a menu bar appears. From...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 3:05 pm
mvillar (6/21/2011)
Windows Server 2008 R2 Enterprise .... and SQL Server 2008 R2... Enterprise too :hehe:
ok how many NICs does each node have? Have you been into adapter settings and set...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 1:45 pm
Brandie Tarvin (6/21/2011)
Perry Whittle (6/21/2011)
you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode
Apparently, I'm missing the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 1:42 pm
george sibbald (6/21/2011)
pls confirm SQL version and OS version, it makes a difference.wheres perry when you need him?
i'm here lol
sunny.tjk (6/21/2011)
Is there a good place to read about SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 1:35 pm
Windows 2008 or Windows 2008 R2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 1:33 pm
you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 7:07 am
george sibbald (6/20/2011)
You can restart a log chain by issuing a differential backup,
indeed, see Paul Randalls article at this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 21, 2011 at 7:01 am
Viewing 15 posts - 7,036 through 7,050 (of 9,241 total)