RE: Replacing SAN on SQL 2000 Cluster
You should be able to detach the databases copy them over to the new san and attach them to your new cluster. I've done several non cluster to cluster moves and that has always worked for me. Wes
2003-06-18
PIVOT
RE: QOD Today
quote: Granted, revoked, denied. Semantics, purely semantics. Why can't engineers, programmers, application designers, system administrators or any other technologists use the language in a way that makes the technology easier to understand? Why does it always seem like so many word games for the purpose of general confusion? You have different people designing different systems. […]
2003-06-18
2003-06-17
RE: Developer tips for team.
Never use reserved words or keywords in your table names (there is a list in BOL but it is so common to see Name and ID used). Do comeup with a standard naming convention for your database objects and never let an object start with or be all numbers. Also, make sure you never use […]
2003-06-16
1 reads
RE: DTS job schedule attempt fails (SQL 42000)
Had the same error message on a different topic after i had installed a named instance. Whist i realised that this will not be the case if you are working in a 7.0 environment, just wondered if you had done a secondry install on your production server. Eventually my errors were resolved by a series […]
2003-06-14
1 reads
RE: Server slow down after stopping replication
Hi all, I have experienced a similar slowdown in EM performance. Removed replication from our server and the database is performing fine for our users, but not while trying to perform basic actions via EM, example opening a restore db window can take several minutes. Any ideas would be appreciated. Thanks, Robert
2003-06-13
2003-06-13
1 reads
RE: ConnectionRead (recv())
Problem Solved. After running a packet sniffer for a while I discovered that there was an ARP request for the IP of the database server right before the problem. So as it turns out there was a network camara sharing its IP address. The camara was on the same network segment so its ARP request […]
2003-06-11
11 reads
RE: SQL Server Agent Fails to Startup
Also please note that I have SQL Mail configured with Outlook and the user profile that I have set up also had its PW changed, which I reverted back to its original PW this morning. I also restarted SQL Mail as well as tested the profile and its working fine. PLEASE HELP - THANKS
2003-06-09
2 reads
RE: IUSR Permissions
When using SQL Query Analyzer: What DB would I run that proc under...master Thanks
2003-06-09
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers