Joe,

not sure what to tell you. I agree that the product should install or you should get support.

Is this a W2K box? If so, I'd be willing to setup...

Joe,

I haven't seen this at all with SQL. It is either a bug or something obscure that you are doing. Are you accepting the default file locations? Are you...

Try this:

http://www.pinnaclepublishing.com/sq/SQMag.nsf/WebIndexByIssue/F36C151BD80FAD8F852568D0007799BE?opendocument

Steve Jones

steve@dkranch.net

I'd send the db and logs to disk locally, then copy them remotely. Then get them on tape.

Here, I send the backups for dbs 4 times a day and logs...

Any chance you could upgrade to 2000?

If not, you can use ADO to run a query from VB/ASP/VBS and then save the query as an XML file.

Steve Jones

steve@dkranch.net

You can backup from one server to another. Depends a little on the SQL version.

For 7/2000, you can use the Enterprise Manager to restore the file, pick device and then...

Here is my reponse:

There are lots of different duties for a DBA and there is not good "job description". I actually started an article on this, but it got...

No real format. Convention is .bak, but not requird. I have use .dmp before. Just be sure you remember what you use.

Steve Jones

steve@dkranch.net

Be sure when you do this, you supply a specific identity value.

Steve Jones

steve@dkranch.net

What do you mean "write the SQL DBA exam?" The exam from MS is already written. You would take the exam I assume.

There are sample questions in most books and...

I agree with Andy. I think the Create Table and Alter Table are pretty tightly linked. I think if you have Create Table, then Alter table is also there.

I'd go...

I tend to agree and with Andy and Brian, but I am confused. It's been awhile since I worked with DSNs (too much of a admin pain), but as I...

I usually setup MSSQL and SQLAGent to run under a domain account that is a member of some global group so I can assign rights. The account is a local...

I used the MeasureUp for the SQL 7 Design exam. It was ok. I've used Transceders for NT 4 exams and they are good, but as a last minute prep...

I fyou change the IIS service to not run the file does it work? I think that you disable te service, start the install and IISReset restarts IIS which can...