Viewing 15 posts - 1,021 through 1,035 (of 1,179 total)
What will happen when we run Rebuild Indexes on Primary Database will it replicate it to Subscriber? or we need extra maintenance plan for Subscriber Database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 9:56 pm
Just right click Database and select 'New Database...'
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 12:48 am
run this t-sql
select name, language from syslogins
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 12:36 am
check this:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/64b2a53d-4416-4a19-acc0-664a61b45348.htm
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 12:07 am
Not getting your problem 🙁
I guess you have connectivity issue. You can check the seting of TCP/IP & Port in SQL Server Configuration Manager.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 7, 2008 at 11:49 pm
Also if no. of members are more than you can create application role and grant permission to perticular role for easy and uniform administration. and assign the db user specific...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 4, 2008 at 3:40 am
Ajay,
following link might help you:
http://www.sqlservercentral.com/About/AboutUs/
Cheers
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 4, 2008 at 2:34 am
Hello Vivien,
Ideal recomendation for cluster is 1 instance on one box i.e. in your environment two instance which will be active / active / passive. Which itself is good combination...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 4, 2008 at 12:43 am
One more thing Mirroring is related to specific Database where Cluster is happening related to SQL Instance.
Also generally Cluster server & failover cluster server should be at the same...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 25, 2008 at 10:40 pm
Hello Elisabeth,
Thanks a lot for quick turn around. Your answer is perfect that's what I was looking for.
I have the same openion like you but customer make me confuse :w00t:....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 25, 2008 at 2:16 am
You can refer the following site:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 20, 2008 at 12:05 am
Try this link:
http://support.microsoft.com/default.aspx/kb/215340
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 19, 2008 at 11:47 pm
In case, if you are changing fillfactor to lower digit surely mdf file will increase. e.g. current fillfactor is 0 or 100 and you define it to 80 surely mdf...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 18, 2008 at 5:04 am
I guess you need to execute
RECONFIGURE [ WITH OVERRIDE ]
to take the effect and restart.
Also /3gb swithch itself notifies that initial pagefile size for sql database is 3 GB.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 18, 2008 at 4:43 am
I fully agreed with FNS.
As I have experience the same thing in my environment. As soon as wintel teams reboot the server works fine and after while again sink. 🙁
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 18, 2008 at 4:17 am
Viewing 15 posts - 1,021 through 1,035 (of 1,179 total)