Viewing 15 posts - 7,141 through 7,155 (of 9,253 total)
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...
April 29, 2011 at 3:01 am
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...
April 29, 2011 at 2:51 am
also bear in mind you will need to be using Enterprise edition to use the Online indexing feature
April 29, 2011 at 2:48 am
Thank you, please don't forget to rate the article
April 27, 2011 at 2:13 pm
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...
April 27, 2011 at 12:33 am
samsql (4/12/2011)
Perry will there be any issue if i truncate the tables.... as i dnt have any space...
April 26, 2011 at 4:29 am
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...
April 20, 2011 at 3:38 pm
Syed Jahanzaib Bin hassan (4/18/2011)
April 18, 2011 at 11:34 pm
Sven Worm (4/17/2011)
This documentation seems to be offline. Does anyone can get it online again ?Thanks
Sven
I have fixed the link for you, right click and download it to hard drive...
April 17, 2011 at 9:41 am
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...
April 15, 2011 at 9:47 am
samsql (4/15/2011)
April 15, 2011 at 8:20 am
RAID10 requires an even number of drives.
The best solution with 12 drives available would possibly be
OS RAID1 (2...
April 14, 2011 at 8:56 am
G.Sudhagar (4/13/2011)
1)first step will delete old backup file based on ur need (days).
you would be well advised to delete files AFTER a successful backup for obvious reasons
TheHose
I use a VB...
April 14, 2011 at 8:42 am
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...
April 14, 2011 at 8:36 am
Andrew Clark-151434 (4/13/2011)
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...
April 13, 2011 at 2:19 pm
Viewing 15 posts - 7,141 through 7,155 (of 9,253 total)