Viewing 15 posts - 6,211 through 6,225 (of 9,241 total)
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
This link provides further details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2011 at 3:19 am
arr.nagaraj (11/24/2011)
I thought on active node and can accept connections and function normally while we install on passive. Can someone clarify
That is correct.
The forums are full of good and bad...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2011 at 12:58 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2011 at 10:00 am
Viewing 15 posts - 6,211 through 6,225 (of 9,241 total)