Viewing 15 posts - 6,616 through 6,630 (of 9,253 total)
dbychen (9/14/2011)
September 15, 2011 at 5:41 am
pamalatha (9/14/2011)
September 15, 2011 at 5:39 am
yes, prevent failback will do it exactly what it says. Set the policy to immediate or scheduled and the cluster group will comply, probably not what you want on a...
September 14, 2011 at 9:23 am
Virtual network names, like computernames must be unique in the domain.
One clustered instance to one network name.
September 14, 2011 at 9:21 am
Please execute the following against your primary server and post the results
exec sp_help_log_shipping_primary_database @database = 'YourLogShippedPrimaryDatabase'
September 14, 2011 at 4:30 am
Possible owners are defined at the resource level and dictate which nodes in the Windows cluster are able to service this resource
September 14, 2011 at 4:12 am
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using Enterprise edition...
September 14, 2011 at 3:42 am
kapfundestanley (9/13/2011)
So you mean on top of the daily back-ups i am taking, i need to take Daily transaction logs as well?
Yes, in full recovery model you need to take...
September 13, 2011 at 5:29 am
Log shipping stored procedures are detailed here
September 13, 2011 at 1:47 am
The paths do not need to be the same. Can you provide more details on the setup?
Is this server part of a windows domain or a workgroup?
What user account do...
September 13, 2011 at 12:09 am
File share witness for Maj Node Sets is a little known trick in Windows 2003 but works well and is a standard quorum option in Windows 2008.
The DTC data must...
September 12, 2011 at 11:17 am
bsegermeister (9/12/2011)
September 12, 2011 at 10:50 am
sqlcool (9/9/2011)
Added the login (company\developers) as dbreader & dbowner
Ensure you make this change at the primary server and simply allow log shipping to take it's course. Also add the server...
September 11, 2011 at 2:14 pm
After the upgrade also run dbcc updateusage on all DBS.
Valid point on replication but it was never mentioned.
Paul given the time it takes to backup, copy, restore especially for large...
September 9, 2011 at 8:13 am
bsegermeister (9/8/2011)
September 9, 2011 at 2:01 am
Viewing 15 posts - 6,616 through 6,630 (of 9,253 total)