Viewing 15 posts - 4,711 through 4,725 (of 9,244 total)
There is a recovery path that has occurred but not been synchronised by log shipping. What does the following return when run against the new mirror principal instance and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 5:10 pm
distas (10/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 2:25 pm
arkiboys (10/25/2012)
In the script, I see the name for the production server.
On running this script in the mdr (mirrored server), do I change the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 8:46 am
bjcharles (10/25/2012)
Perry Whittle (10/25/2012)
Elizabeth.Block (10/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 8:00 am
Elizabeth.Block (10/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 6:50 am
arkiboys (10/25/2012)
GilaMonster (10/25/2012)
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
How...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 6:00 am
arkiboys (10/25/2012)
GilaMonster (10/25/2012)
SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 5:59 am
This is an improvement
selectOBJECT_NAME(i.object_id) AS TableName
, i.name AS IndexName
, FILEGROUP_NAME(i.data_space_id) AS FileGrpName
from sys.indexes i inner join sys.objects o
on i.object_id = o.object_id
where i.index_id = 1 and o.is_ms_shipped <> 1
and i.data_space_id...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 5:55 am
Ratheesh.K.Nair (10/25/2012)
give server name as smtp.gmail.com and check the ssl.Try the below link.
You can only route your mail through google mail or windows live if you have a gmail or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 4:12 am
The listener has no concept of instance names, its a connection route into the AlwaysOn availability group. What details are you using to connect via the listener?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 4:04 am
Something along the lines of this should get you started
Select * from sys.indexes
Where index_id = 1
And data_space_id > 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2012 at 11:58 pm
I suspect theres a deeper issue here. You dont want to be using dynamic disks, these are only designed for use when you want to crete a software raid through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2012 at 11:52 pm
mrtrich99 (10/24/2012)
Perry Whittle (10/20/2012)
mrtrich99 (10/19/2012)
The server response was: 5.7.1 Unable to relay for testuser@company.com). ).............
...........Any suggestions on what else I can do to troubleshoot the "Unable to Relay" issue?
You're...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2012 at 10:59 am
The default timeout is set to 10, you will want to test network connectivity though and adjust this before implementing mirroring.
Can provide more detail about your mirroring setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2012 at 6:52 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2012 at 12:00 pm
Viewing 15 posts - 4,711 through 4,725 (of 9,244 total)