Viewing 15 posts - 4,696 through 4,710 (of 9,244 total)
yes, mirror is switched off when indicated to do so under SQL Server 2008 but the mirror partner thinks that the mirror relationship is still in place under 2012
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 8:45 am
raheelr 63130 (10/28/2012)
Hi Techs, is it possible to have DB level clustering in sql 2008? if so how can we achieve this?I know DB levek mirroring does work.
Regards
Raheel
Database mirroring offers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 6:49 am
guerillaunit (10/28/2012)
DECLARE @MYHEX AS VARCHAR(MAX)
SET @MYHEX = '0000C180880810010000'
SELECT CONVERT(VARBINARY(MAX), @MYHEX, 1)
I get this error...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 4:23 pm
Indianrock (6/3/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 3:26 pm
Indianrock (6/4/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 3:11 pm
Joie Andrew (10/28/2012)
RESTORE <database_name> WITH RECOVERY
If it succeeds...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 2:47 pm
I've recreated this under 2012 and the only way i could remove the broken mirrored db was to stop the SQL Server service and delete the db disk files then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 9:32 am
The product itself coupled with books online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 4:55 am
you should be able to remove the database using
DROP DATABASE yourdb
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 3:21 pm
Brandie Tarvin (10/26/2012)
Supply their own equipment? I mean, phones I get. But laptops?
This is quite common for contract staff
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 11:13 am
so what is the current state of the principal is it still connected?
Post the results of the following please against the principal instance
select * from sys.database_mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 8:45 am
w8buch 88800 (10/26/2012)
Sooo, I tried to disable db mirroring on the mirror using ALTER DATABASE db SET PARTNER OFF;, which completed successfully, but the DB STILL remained in a mirrored-configuration.
It...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 8:21 am
n00bDBA (10/26/2012)
Is it possible to list out all the tables/SP in a database and if a role has a GRANT on it what it allows...
I cant find...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 5:33 am
I saw an advert for a contract here in the UK only last week and the agency stated
Must have 5+ years experience on SQL Server 2008 R2
Now, remind me, what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 2:00 am
Elizabeth.Block (10/25/2012)
Thank you both for your replies! I thought that database snapshots might be the same as the snapshots used for replication but wasn't sure.
You're welcome. I guessed that's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 1:42 am
Viewing 15 posts - 4,696 through 4,710 (of 9,244 total)