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...

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...

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...

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...

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....

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...

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

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...

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...

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...

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...

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...

quote:

---

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

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...

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...