Forum Replies Created

Viewing 15 posts - 16 through 30 (of 32 total)

  • RE: New SQL server built but no down time allowed

    Earlier I mentioned log truncation. A full backup does this - not me. I was just thinking out loud at what all happens.... 

    I have the latest builds on both boxes. ...

  • RE: New SQL server built but no down time allowed

    So what I am hearing, and PLEASE correct me if I am wrong, is this:

    If I am to the point where I can restore last nights full backups (meaning my...

  • RE: Restore Database Fails

    Dont forget you can restore from the QA using something like:

    restore database JUNKNAME from disk="c:\righthere\junk.bak'

    See BOL for more on Restore.

    It is worth a shot to see if it bombs out...

  • RE: Connections from Application are getting disconnected

    At the point of sounding presumptuous, I'll restate the above reply in more frank terms.

    FIX  your jobs that are running during that time, like...

  • RE: spontaneously dropped db''''s

    This is not something I wanted to admit.  Being the first week on a new job, I had rather take the blame for something I may have done than suspect...

  • RE: spontaneously dropped db''''s

    The logs show nothing.  The closest thing I can come to an answer is probably my fault.  I stopped a backup of Master midstream, then redirected the backup to a...

  • RE: spontaneously dropped db''''s

    Yes, detached and not dropped.  They were reattached without incident but the question still remains has anyone ever seen something cause a detachment that appeared to be rather spontaneous?

     

    Studdy

  • RE: Extract Data from PDF

    PDF files are 7-bit ASCII textfiles. They can be opened in any editor or wordprocessor like Microsoft Word or Wordpad unless the text has been compressed.

    Every line in a...

  • RE: Sql Server & Memroy

    Never think that memory "thrown at it" will solve all performance related issues...as a general rule, the more - the better - but performance is a broad brush that paints...

  • RE: Need to archive data off the server

    Does anyone really believe media or hardware that is used now will even be functional in 7 years?

    The thing is, about at 2 to 3 years, you need to set...

  • RE: One of 4 processors getting beat to death

    Service Pack 3 for SQL 2000.

    Wondering if I need to lower the parallel query processing time from the default of 5 to about 2? 

  • RE: Perf Mon and SQL Profiler

    Direct them to Microsoft's TechNet site and it will explain about the minimal overhead - which is primarily display related.

    Of course, if you are storing large amounts of Profiler data,...

  • RE: How to read from a CSV file in a sProc?

    If you prefer GUI's (and I do) AND the file to import is not one HUGE S.O.B. (because bcp is probably a smidgeon faster) then the easy thing to do...

  • RE: Useage testing (each database %)

    Database id will do it.  I just checked, and thanks.

     

    Studdy

  • RE: Inputting single code string data

    Can't you change it to the ansi charachter that it represents?

    Like Chr(143) or similar?

Viewing 15 posts - 16 through 30 (of 32 total)