Viewing 15 posts - 7,126 through 7,140 (of 9,241 total)
the article is correct, subst will not work especially if the service runs under a user account. The steps are perfectly reasonable, although i have to say this topic (starting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2011 at 1:40 am
samsql (5/3/2011)
. so wat shud be action plan...
See my last response above!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2011 at 11:53 pm
Syed Jahanzaib Bin hassan (4/29/2011)
ACTIVE/ACTIVE means 2 separate instances in a cluster,there is no load balancing
Active\Active means more than one instance of SQL server active on more than 1 cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 12:08 pm
you may also need to cleanse AD and DNS too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 3:11 am
Elliott Whitlow (4/26/2011)
if I were to build a 4-node cluster where there were 3 x 2-node SQL clusters, would that be allowed.
That would form the base Windows cluster and is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 3:06 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 2:51 am
Thank you, please don't forget to rate the article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2011 at 3:38 pm
Syed Jahanzaib Bin hassan (4/18/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2011 at 9:47 am
samsql (4/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2011 at 8:20 am
Viewing 15 posts - 7,126 through 7,140 (of 9,241 total)