Viewing 15 posts - 1 through 15 (of 19 total)
You do not need 32-bit client, unless some 32-bit apps are running on your server and trying to connect Oracle databases.
Oracle Client should be installed on all the nodes of...
May 16, 2013 at 12:21 am
The best way to save backup space would be to rebuild your indexes before the full backup.
May 16, 2013 at 12:12 am
Lesson learnt - never ever use the CLR 🙂
April 30, 2013 at 10:38 pm
We are forced to take all the 2+ months leave.
But I'm in Australia, so things are quite different here - we even have a socialist government (Labor one)! 😀
April 29, 2013 at 7:03 pm
Jpotucek (4/17/2013)
I have a Database (about 1GB) with 2 log files (one at about 4GB and one at about 13 GB)
Just a note - a SQL Server database cannot...
April 17, 2013 at 9:20 pm
Try this:
Alter database <DBNAme> set single_user with rollback immediate
go
<your restore statement>
go
alter database <DBNAme> set multi_user
go
April 17, 2013 at 9:16 pm
The Data Collection does it for you as well - the snapshots.disk_usage table contains db space info.
January 23, 2013 at 5:08 pm
The script fails if you have any mirrored databases
May 21, 2012 at 6:13 pm
The script fails if there are any non-active databases (mirrored ones, for example)
September 6, 2011 at 5:52 pm
GRANT EXECUTE ON SCHEMA::dbo TO USER1
December 13, 2010 at 3:40 pm
jcrawf02 (9/8/2010)I saw that one, I meant a coherent request like yours: 😉
I'd like to see Express not only have a very simple setup that works across multiple versions...
September 8, 2010 at 9:01 pm
Well, wouldn't it be easier to suspend DB mirrorring session in this case?
In case of upgrade failure: 1)turn off db mirrorring; 2) bring mirror db online.
3 t-sql statements in total:
1)...
August 19, 2010 at 8:31 pm
george sibbald (1/7/2010)
well if someone said to me its an active\active cluster I would know what they meant, so that's good enough for me. 🙂
You do, but I've met a...
January 7, 2010 at 3:45 pm
george sibbald (1/7/2010)
simon.murin (1/7/2010)
Ali_SQLDBA (1/6/2010)
My cluster is a AA cluster. So, I need to install on both nodes then. correct?
Well, I don't like to open a can of worms, but...
January 7, 2010 at 3:25 pm
Viewing 15 posts - 1 through 15 (of 19 total)