Hi Experts, I need to plan space and drive allocation for 800 GB sharepoint database and I was asked to give the requirements/specification to system...
Hi All, I need some clarifications regarding log backup and restoration .... Assume that I have full backup at 3am, diff backup at 2pm and log backup...
Hi All, I am trying to take a database backup from a sql server which is on 'x' domain and trying to store it on 'y' domain and I get the below...
Is it possible to set up replication from sql 2000(publisher) to sql 2005(subscriber)? It is not showing an option to subscribe to SQL 2005 server....
Is it possible to restrict a SQL login if it is connecting from a particular host/system?Or Is it possible to restrict a SQL login if it is...
I have scheduled a reindex which is failed on last sunday. I didn't find any reason for the failure. I have checked the event viewer and sql server...
Hi, I have 4-5 databases that include the production db on the production box. Intermittently my tempdb grows to larger size. I am sure my...
Our DB production server is built with 64bit type O/S. We are thinking to install 32 bit MOM Agent on our DB server which is 64 bit. Any idea...
I tried rebuilding the index with online and offline mode, even then the avg_fragmentation_in_percent is not getting reduced? Is there any logical...
Hi, I would like to schedule some maintenance tasks on my db server. I have confusion in this. What is the difference and purpose between update...
Hi, I am new to clustering concepts, so bear with me for my silly questions. I did something like ‘initiate failure#%92 yesterday on my cluster...
I have a test server where the sql server is clustered. I just want to perform a simple failover test, just want to see how the node b takes the...
What are the mandatory maintenance plan should be scheduled on the production server? Thanks, Bala
I want to change the service account password(forgotten) and the sql server is clustered. What are the necessary steps to be taken before doing...
Counter_Name Average Minimum Maximum ----------------------------------------------------------------------------------------- Memory: Pages/sec...
I have scheduled performance monitor files, it ran for 5 hours and it created a file as .blg file under c:perflogs. Using this file, I want to find...
Hi, I just want to know, is there any difference,advantages or disadvantages in using openquery & four-part names(linked server)? I generally use...
I am getting problem in the sp when using single quotes. The following is the parameter i am passing. exec get_por @broker_list='AAA' The...
Hi, I have a table like below: id, value 1 a 1 b 1 c 2 x 2 y 2 z 3 i 3...
Hi,<br /><br />I have a syntax below to specify a condition...<br /><br />and (<b>cast</b>(left(stat_period,4)+'-'+substring(<b>cast</b>(stat_period...
Separate names with a comma.
