I have fixed the link for you, right click and download it to hard drive...

Sorry i do apologise, i forgot the WHERE clause :blush:

Please execute this against MSDB and post results

select object_name(object_id),

(used_page_count * 8) / 1024 as TableSizeInMBs,

row_count

from sys.dm_db_partition_stats

where index_id in (0,1)

order...

samsql (4/15/2011)

---

Thkz for the reply below are the details for one server msdb :- also there are more server where the size and count is more ...

RAID10 requires an even number of drives.

The best solution with 12 drives available would possibly be

OS RAID1 (2...

you would be well advised to delete files AFTER a successful backup for obvious reasons

TheHose

I use a VB...

SQLIO stress testing will primarily affect the SAN so no you wouldn't run it on production. These sorts of tests should be carried out before the Server and SAN are...

Andrew Clark-151434 (4/13/2011)

---

Hello,

Thanks for any replies, I have found the problem. Our AD replication wasn't working so any permission changes on AD accounts weren't replicating for about 13 hours. Once...

no need to take a FULL backup here to restart the log chain, a DIFFERENTIAL will suffice and allow subsequent transaction log backups

why are you bothering to offload this through SQL Server? Send mail directly from the app straight to the SMTP server using System.Net.Mail class, there is a MailMessage() object there...

Hi

execute the following against MSDB and post the results

select object_name(object_id),

(used_page_count * 8) / 1024 as TableSizeInMBs,

row_count

from sys.dm_db_partition_stats

order by row_count desc

i'm guessing this interfaces with VCB and snapshots the VM's virtual disks!

the stored procedure

sp_delete_backuphistory

is used to trim the history tables. You can find details of this in Books Online

forsqlserver (4/11/2011)

---

I am starting to create SQL Server Cluster on 2 servers and on both one Warnng is coming.Should I start it?

[highlight=#ffff11]Windows detected your registry file is still in use...

clustering requires AD and AD is dependant upon DNS, they are all tied very neatly together.

Just out of interest, why do you ask if you can implement clustering without these...

Further to what Jeffrey has said, you get the option during the SQL Server 2008 install to use service account SID based security or traditional global\local group security. Obviously service...