Is SQL Litespeed faster/slower than SQL Native backup ? Is it more CPU/Mem intense than SQL Native backup ? Can a SQL Litespeed backup be restored using SQL native restore and vice versa ? Using SQL 2000 and may wish to buy/try the latest SQL Litespeed Any cons using Litespeed that one ne...more >>

Windows 2000 AS sp4 SQL Server 2000 EE sp3+ My client is testing an application that requires us to change the date on the staging database server. The database server is a virtual server on a cluster. Therefore, I would have to change the date on the node that owns the virtual server. Does...more >>

I have an active/passive database cluster that's overloaded, with nowhere to offload the excess to. Are there reasons for not going to an active/active cluster? Any big gotcha's? I seem to remember hearing (some time back) that active/active was not a good idea, or at lease not recomm...more >>

Is it possible to disable Named Pipes protocol via Server Network Utility? I noticed that ability to disable Named Pipes is grayed out on some of my SQL clusters but not on others. I'm guessing this has to do with SQL SP3a disabling this option. Are there reasons not to disable Name Pipes...more >>

Hi Is there any way to get a totally seamless transition to a fail over server? At the moment, if the primary node goes down then the standby node picks this up within about 10 seconds...which is fine. But, if I'm editing a table during the fail-over then it freezes my connection and does...more >>

G'day I have a couple of questions I am hoping someone can help me with 1) From the SQL Server point of view, are there any additional considerations when deploying a stretched cluster, rather then a normal cluster? 2) Are there any SQL Server components that work on a normal clust...more >>

2 node windows 2000/SQL 2000 cluster 1 default instance and 2 virtual servers default instance is set to use AWE, and min and max memory of 4096 2 virtual servers are set to use AWE, and min and max memory of 2096 When the default instance loads it consumes 4096 MB of RAM immediately, I s...more >>

I have a 2 node Windows2000/SQL2000 cluster residing on a Windows NT 4.0 Domain. I need to upgrade the domain server and am concerned about the status of the cluster once I upgrade. If anyone has any experience with this or could point me in the right direction it would be greatly apprecia...more >>

Listed below are the IP Address that correspond to my Cluster. Should the DSN server be set up so that Virtual SQL Server names are assigned an IP Address. Names IP Addresses 1. BVLDBP01A (Public) 198.159.209.67 2. BVLDBP01A (Private) 10.10.10.1 3. BVLDBPVS01...more >>

Hi, i have a soft that works using MSDE as db engine. My soft have a server version and a client version, but they use a local copy of the database. One generic client sends once a day all his new records.. and downloads the new records from the server.. (other records may come from the server.....more >>

Hi, What are the disadvantages with Primary Key. Is all tables required to have P.K. Thanks ...more >>

Hi Two-parter question if I may: I have inherited a web-based database application. This application is effectively sold to our customers but hosted on our own machine. Each customer has their own copy of the SQL Server 2000 database. One thing we used to do was real-time replication be...more >>

Two questions: 1. Has anyone used MS's database hammer tool that comes with the resource kit? I'm running into errors when running the loadmaster app Any info on your real life experience would be greatly appreciated. 2. Has anyone have real world experience setting up a geographically ...more >>

Hi All, I want to know, Does MSDE support database cluster? Is anybody has done this? Any information about this will be highly appreciated. Regards, Rajesh...more >>

Hi Friends, On the SQL Server cluster we need bak and restore. For this I have a question - When the i m taking a backuo on a server and server failover to another server and backup is not complete. What will happen to the Backup it will be completed by the next Server or it will fail...more >>

The clustered index stores the data pages at the leaf level. What will it store at root and intermedaite levels. Storing data pages at leaf level means, will it store the entire data row or only cluster key columns....more >>

Hello, I have two arrays setup on an external drive array. I have already setup MSCS and it has put these two arrays into seperate groups, lts call group1 and group2. I want to install SQL and use group1 for the SQL data and group2 for the SQL Transaction Logs. Is this possibe? How would...more >>

I recently started this position and one of my first tasks was to create a cluster for a SQL database. The existing DB is on a single server, with replication to several backup servers. I've built the cluster and and am getting ready to install SQL. My question: What is the best approach to movi...more >>