Forum Replies Created

Viewing 15 posts - 1 through 15 (of 33 total)

  • RE: DR testing

    I ended up 'cheating' and doing a Veritas backup to tape while the SQL servr services were down and storing this as a special, not to be over-written tape. Then...

  • RE: DR testing

    Yes, but when I did the rebuildm I selected the same settings as had been revealed to me from the restore headeronly, i.e. dict order, case sensitive, general unicode and...

  • RE: DR testing

    Thanks for that! I ran it on a 'spare' SQLServer server that I just happened to have and got the following

    Sort Order 51 - which I have discovered is case...

  • RE: SQL 2000 SP3

    I have just installed SQL 2000 Enterprise edition onto a brand new Windows 2000 machine. Being good I applied SP3 to SQL and now when I try to look...

  • RE: Problem Restoring Master DB

    One of the scenarios I use when doing DR tests is

    I. Rebuild SQL Server via rebuildm

    II. Bring SQL Server up in single user mode

    III. Recover master

    IV. Restart SQL Server service

    V....

  • RE: Taskpad View in EM

    I haven't - I was mightily confused when trying to talk someone through a procedure I wanted them to carry out. They were in Belgium, I had no sight of...

  • RE: Binary data in database

    I agree with Antares686 - we store our PDFs to disk and store links in database. It is easiest and least painful!

  • RE: How have you improved the SQL Servers at your work

    The biggest improvement I made was to get rid of replication!

    When I inherited the servers the set up was 1 server here which had all the data on it, and...

  • RE: What do you like best about databases?

    I must admit that the part of my job as DBA I enjoy the most is the preparation, maintaining and testing of the Disaster Recovery procedures - I know I...

  • RE: Restore of SQL 2K

    We took the same approach as Brian with our DR tests and I must say it was plain sailing all the way.

    We also did a couple of backups with...

  • RE: Why did you decide to become a DBA/SQL Programmer?

    For me it just kind of snuck up on me while my back was turned!

    I started out life as a Programmer in a VAX VMS environment. After many years as...

  • RE: 50 Ways to Confuse, Worry, or just Scare People in a computer lab.

    This kind of reminded me of the things we did when I was at college - number 5 especially if an artsie type course was next in there to do...

  • RE: Veritas Backup/Restore

    quote:


    BOY does this sound familiar! However, if I was told to report to our Tech Mgr, I would have to quit...

  • RE: Scheduling Batch Cmd from SQLAgent

    I asked about the enabled box because I had a job set up where the enabled box was not checked and it just refused to do a thing - not...

  • RE: Scheduling Batch Cmd from SQLAgent

    You have set command type as operating system command, then entered command in the command box eg: e:\eis\jobs\updates.bat. where updates.bat is you batch command file.

    You have checked the enabled box?

    Who...

Viewing 15 posts - 1 through 15 (of 33 total)