Viewing 15 posts - 4,696 through 4,710 (of 9,241 total)
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
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
Viewing 15 posts - 4,696 through 4,710 (of 9,241 total)