Viewing 15 posts - 6,211 through 6,225 (of 9,244 total)
Here's the MS resource for Windows 2008 MSDTC
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2011 at 9:04 am
its no longer enforced but i implement it for the following reason
you have NodeA and NodeB and the clustered sql server instance uses the virtual network name CLUSNODE1, it is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2011 at 8:34 am
if you're unsure then open the Litespeed console and step through the backup or restore process for your chosen database. At the end of the wizard, before executing, there is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2011 at 4:58 am
Dude Dev
please accept my apologies 😉
On a side note the other thing that will commonly interrupt the log shipping is a manual transaction log backup that is not part of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 7, 2011 at 4:05 am
MyDoggieJessie (12/2/2011)
About 300 miles
😀
you want to try 6000miles 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 2:48 pm
Dev (12/6/2011)
Perry Whittle (12/6/2011)
Dev (12/5/2011)
It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).
Log shipping...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 2:28 pm
adrian-844207 (12/3/2011)
None of the servers is in a domain.
so how come your script above references server1.ourdomain.com and server2.ourdomain.com
If setting up mirrroring in a workgroup please see the following article
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 1:53 pm
Dev (12/5/2011)
It sounds OK. Just make sure once you enable jobs they restore the backups in proper sequence (without breaking the chain).
Log shipping will automatically restore the logs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 1:55 am
SQLRNNR (12/5/2011)
With SSRS 2008, no IIS involved.
No IIS management console, but SSRS 2008 still uses the same HTTP.SYS driver that IIS would use
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 1:50 am
adrian-844207 (12/3/2011)
alter database citec_vc_prod set witness = 'TCP://witness_address:witness_port';
Where are you executing this command from?
Have you double checked the steps to create the certificate and the user?
What value are you supplying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2011 at 1:45 am
can you post details of the script?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2011 at 3:07 pm
you could use SMS or group policy to push out the DSN registry change to all desktops, i have done this before with ease when migrating a database between a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2011 at 2:23 am
azhar.iqbal499 (12/1/2011)
So What security meausres should I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2011 at 2:14 am
are you backing up via the gui, command line or the extended SP's
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2011 at 4:15 pm
Banana-823045 (10/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2011 at 3:59 pm
Viewing 15 posts - 6,211 through 6,225 (of 9,244 total)