Ahh, OK. Definitely check the network response and stability between the VM and the physical node too if you can.

Do you have access to the VI client? You can create rules regarding VM movement when DRS is enabled on the ESX cluster

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...

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...

yes!

add them to the model database on that instance

Ha ha, pull your tongue out of his backside will you :Whistling:

Making...

Good luck with the upgrade Wayne, be interesting to...

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...

I'm...

Problem is, this just causes the database to grow again!! All that I\O to shrink is now...

It's important to note that Kimberley merely advises that...

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

danfugett (11/1/2010)

---

We have a new network share to backup sql files to. We are using the destination format \\10.1.20.50\sqlbackups\Production\foldername. We can get all the backup scripts to backup to this...

does the report use an embedded data source or separate SSRS stored data source? How is this data source configured?