Viewing 15 posts - 5,521 through 5,535 (of 9,244 total)
Before you just go detaching databases you may want to record their physical and logical filenames. Do this using
select 'Logical file ''' + name + ''' from database ' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 2:11 pm
Don't know offhand, but just open up the restore window and try to locate the new drive, if it doesn't like it it will soon let you know.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 4:50 am
srivathsani-296624 (5/31/2012)
We are not sure if the node is still a part of the cluster
Windows 2003 or Windows 2008?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2012 at 4:26 pm
APA0876 (5/30/2012)
what do you recommend for 2 nodes active\active , 2 sql server instancesThanks
APA
Are you expecting a large amount of remote transactions on each instance? One DTC for each instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2012 at 4:21 pm
SQL Kiwi (5/29/2012)
A recent discussion on the MVP mailing list came to the unanimous conclusion that 4GB was fine for large-memory systems.
Were they Windows server MVPs?
GilaMonster (5/29/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2012 at 4:10 am
michael vessey (5/28/2012)
does that include the heartbeat IP addresses as well?
No Mike, and for 3 very good reasons
➡ Your public network possibly services 100's or 1000's of IP addresses and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 3:52 pm
The page file is a windows host configuration best practice. Ideally you should size it appropriately and place it on a separate disk
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 3:43 pm
to get the date of the latest stats updates for a given database, use the following
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 10:02 am
viswanathan.mathi (5/28/2012)
Hi Friends,I want to know the no of ip address required for active passive cluster active/active cluster
You require
1 IP address for each cluster node
1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 9:54 am
Great, thanks for posting back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2012 at 6:46 am
MysteryJimbo (5/26/2012)
Theres a risk of accidentally deleting or loosing the files when in a detached state.
Take a database offline and then try to delete, move or rename one of its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 4:33 am
Check your cluster validation report. Have you put all related disks for the mount pints into an app group and set the dependencies
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:49 am
cfradenburg (5/25/2012)
A user (db level) doesn't work without a login (instance level).
It does, but you to use EXECUTE AS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:46 am
I've never found a detached database difficult to re attach, unless of course some clown moves the files instead of copying them.
Even with backup and restore you want the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:44 am
sbaker-757360 (5/24/2012)
I tested complete network failure as described above...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 4:06 pm
Viewing 15 posts - 5,521 through 5,535 (of 9,244 total)