Viewing 15 posts - 7,036 through 7,050 (of 9,244 total)
The main issue you'll face is around windows accounts. As I already mentioned the stored procedure will script certain windows accounts that you don't want to apply to the target....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2011 at 1:06 am
How large is the database that fails to backup?
How much free space is available on the network location?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2011 at 4:21 pm
In my experience with NetApp filers all disks are usually part of the same aggregate with volumes and LUNs carved out of the aggregate and surprisingly enough this is NetApps...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2011 at 4:16 pm
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
Viewing 15 posts - 7,036 through 7,050 (of 9,244 total)