Hi! I need to configure Raid on our SAN.I have around 600 databases.Some of them are extensive read and write.Now I am wondering which Raid level to...
I need to set up MSDTC for my majority node set cluster.I am running comclust.exe command at a command prompt, But this commands just open up the...
We are in a process to set up replicatication.I need to list the pros and cons of pull and push subscription.More over we need to know , which one is...
I want to add a super user like 'sa' which cannot be dropped.I am wondering how can I do so. This I need for administrative purpose
I need to set up a transactional repl,where my present production box will act both as a publisher and distributer. Now I am wondering how can I do...
Hi! I gusess I posted a confused matter in my last post,so I didnt get any response.Here is a bit modified post Is it possible to have a cluster...
We need to build a cluster group such that the clustered node in one geographical place and the replicated stand by in other geographical place It...
Hi!All Recently we are undergoing change management. In one phase we stucked.At present all the application hosted on IIS are using dsn to connect...
Hi! Recently we have installed sql server sp4.I am wondering does it has any security flaws. I have found the list of fixed issues in sql server sp4...
Recently I installed SP4 and after the installation is finished. When I tried to connect to sql server by QA using windows authentication I got this...
Hi! I need to write a script which will flush the the cache on a scheduled basis. Is there is any system stored procedure by which I can accomplish...
Hi! I want to create a folder and inside that folder the mdf and ldf files.The name of db and folder is picked from a text file.I am doing like this....
HI! Recently I have heard that semi joins give better performance compared to outer joins when working with distributed databases. I have gone...
I have a table for which I have defined the cust_id coloumn as primary key.Now clustured index is created on pimary key. Is there is any necessity to...
We have a third party backup tool which takes backup every night.Previous night the backup was delayed automatically.(by almost 5 hours.it started 5...
I have a database with 1 user and that user has been assigned db_backupoperator fixed db role.Now this user doesent have been assigned sysadmin or...
Some of my databases have gone suspected day before yesterday.I am wondering is there is any way to know which of these databases are.I have gone...
I already have SP3 on all my sql server.Now I want to install SP4 on these server,I am wondering do I have to remove/uninstall SP3 before installing...
I have a job which run at 2am every day to truncate log file. The job contains simple BACKUP LOG 'dbname' WITH TRUNCATE_ONLY DBCC...
10 of My databases are in suspect mode automatically.The log file exist and hard disk id fine .What should I do to make them healthy
Separate names with a comma.
