Viewing 15 posts - 7,426 through 7,440 (of 9,244 total)
Ahh, OK. Definitely check the network response and stability between the VM and the physical node too if you can.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 1:19 pm
Do you have access to the VI client? You can create rules regarding VM movement when DRS is enabled on the ESX cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 10:48 am
Hi
What makes you think it's VMotion, do you supsect manual or automatic VM movement?
One thing to check would be the network stack between the physical and virtual networks, any issues...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 10:24 am
Public is already an inherited role for all users. Try the following
exec sp_msforeachdb 'use [?];
create user [domain\user];
exec sp_addrolemember ''db_backupoperator'', ''domain\user'';
exec sp_addrolemember ''db_denydatareader'', ''domain\user'';'
Ignore output messages indicating the database user...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 10:16 am
yes!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 9:43 am
smitty-1088185 (11/3/2010)
How do you automatically give the Database level permissions to any new databases created by another team?
add them to the model database on that instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 9:32 am
HoustonFirefox (11/1/2010)
I admire and learn a great deal from my collegues here and respect everyones point of view.
Ha ha, pull your tongue out of his backside will you :Whistling:
Making...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:18 am
WayneS (11/2/2010)
We're having an outage this weekend when we're upgrading to SQL 2008... I plan on using this time to do this.
Good luck with the upgrade Wayne, be interesting to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:08 am
From BOL
To enable log shipping
➡ Initialize the secondary database by restoring a full backup of the primary database on the secondary server.
➡ On the primary server, execute sp_add_log_shipping_primary_database to add...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:04 am
chris.s.powell (11/2/2010)
As for the rebuild index, it will be recorded in the log file, with a proper backup plan in place, that space will be freed after it is completed.
I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:35 am
chris.s.powell (11/2/2010)
please make sure you rebuild your indexes and statistics when this is completed!!!!
Problem is, this just causes the database to grow again!! All that I\O to shrink is now...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:11 am
Kimberley Tripp
Wait for an inactive time of day (ideally, it would be best to put the database into single user mode first)
It's important to note that Kimberley merely advises that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:03 am
sais
please post the results of the following query executed against your database
select[FileSizeMB] = convert(numeric(10,2)
, round(a.size/128.,2))
, [UsedSpaceMB] = convert(numeric(10,2)
, round(fileproperty( a.name,'SpaceUsed')/128.,2))
, [UnusedSpaceMB] = convert(numeric(10,2)
, round((a.size-fileproperty( a.name,'SpaceUsed'))/128.,2))
, [DBFileName] = a.name
from sysfiles a
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 7:56 am
danfugett (11/1/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 7:38 am
does the report use an embedded data source or separate SSRS stored data source? How is this data source configured?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 5:54 am
Viewing 15 posts - 7,426 through 7,440 (of 9,244 total)