Forum Replies Created

Viewing 15 posts - 61 through 75 (of 244 total)

  • RE: How to get the data there ....

    I think compression is your best bet. Can you zip or use a product like light speed to compress a backup, then move those across your network and restore on...

  • RE: Copy Database/Login Question

    Are you sure its a login problem or is the issue that it cannot find the server? Are you passing the instance name along in the login string?

  • RE: How to delete or shrink a transaction log file.

    Yes you should find the root cause of the growth and attempt to kill it. In the interim why not do frequent transaction log backups and just delete backups when...

  • RE: Blade Server and FC Storage

    Sure we do this all the time. The big limitation with blades is the expandability - particularly cpu's and PCI slots. So we don't put anything needing extreme performance (8X...

  • RE: 5 TB database backup

    Is this on a SAN? Many higher end SANS will now do Snapshot backups. The SAN disks are momentarily paused with writes going to cache, then a snapshot is taken....

  • RE: Reporting on data from three databases

    What kind of performance issues? Can you get the individual queries to the differents systems to work ok? If on different servers, add them as liked servers onto 1 of...

  • RE: moving log file of user database

    I have had similiar issues with drives that have bad sectors. Is the disk new? How was it formatted (RAID controller, OS ...)? Have you tried to reformat the disk?...

  • RE: Hard at Work

    I work 7:45 to 5:15 with a 30 minute lunch. The concept being that I take every other wednesday off. However that only occasionally happens as I have meetings, system...

  • RE: Upgrade RAID Array

    I would also put my plug in for the speed of the disks. Raid 1 with 10K disks might be slower than raid 5 with 15K. (assuming your controller can...

  • RE: creating system dsn to sql server 2k

    Have you tried connecting with Bliss's IP (XXX.XXX.XXX.XXX) instead of the name? Or tried the fully qualified domain name e.g. bliss.med.com?  If you could get to a command prompt I...

  • RE: SQL 2000 Standy License

    For SQL 2000 the answer is here http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0461.mspx?mfr=true

    "All Active servers in a cluster must be fully licensed, with either Processor Licenses or Server Licenses. However, if a server is...

  • RE: SQL 2000 Standy License

    I agree with Lynn. And a reseller audit is somewhat suspect as you know they want to sell you more product. When in doubt call MS. I was completly boggled...

  • RE: DBA''''s more scarce in 2007

    I've tried to hire 3 DBA's since 2001 and I have never gotten a very good pool. Usually the bulk of applicants are Network admins that have "installed SQL Server"...

  • RE: Fuzzy Logic

    hmm good question. My knee jerk reaction would be to union the tables together (probably make a view) and do a fuzzy grouping to find the grouping of common customers.(

  • RE: Using Fuzzy Lookups for Record Linkage

    I agree with Mr Dougherty, in a perfect world we would not want or need to do this. Unfortunately when you get patients in the ER, getting a correct spelling...

Viewing 15 posts - 61 through 75 (of 244 total)