Firstly, mirroring is way easier to set up and maintain than replication.

You may change the default timeout for mirroring using the following

ALTER DATABASE mydatabase SET PARTNER TIMEOUT 90

This will...

providing the builds are in sync you can just restore the master database in single user mode. The master database paths are held in the registry as startup parameters for...

also bear in mind you will need to be using Enterprise edition to use the Online indexing feature

Thank you, please don't forget to rate the article

What command are you using to execute sp_delete_backuphistory?

Both those procedures I have mentioned trim their related tables, you need to decide how history you will keep. Execute the procedures trimming...

samsql (4/12/2011)

---

Thankz perry but it does not delete the data from all the tables....

Perry will there be any issue if i truncate the tables.... as i dnt have any space...

Again starting with Windows 2008 you can map MSDTC resources to chosen cluster service groups although putting the MSDTC in the same group should enable it to be used by...

Syed Jahanzaib Bin hassan (4/18/2011)

---

you have required 1 DTC and 1 Qurum in Active\Passive,Microsoft is not providing till any load balancing solution in cluster which one you are saying ACTIVE\ACTIVE,NLB...

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