Viewing 15 posts - 39,721 through 39,735 (of 39,791 total)
BTW, I can't comment on the Sybex book because I co-wrote it and haven't used any other books. I did think this exam was easier than the 7.0 exam.
Steve Jones
August 6, 2001 at 12:34 pm
Just tried it and I get a 1 also as the result code from the removal.
I suspect this is a bug, but I will have to check.
BTW, I assume you...
August 6, 2001 at 12:31 pm
August 6, 2001 at 12:26 pm
If you make the change in EM and then click the "script" button (3rd from left) you should see this. Many things you do in EM are only possible...
August 6, 2001 at 12:24 pm
August 6, 2001 at 12:02 pm
Be sure your transaction loading is not a single transaction. the log will not truncate open transactions.
Steve Jones
August 1, 2001 at 11:27 am
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...
July 30, 2001 at 3:48 pm
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...
July 30, 2001 at 12:43 pm
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...
July 30, 2001 at 12:22 pm
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
July 30, 2001 at 12:15 pm
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...
July 27, 2001 at 3:54 pm
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...
July 27, 2001 at 12:40 pm
No real format. Convention is .bak, but not requird. I have use .dmp before. Just be sure you remember what you use.
Steve Jones
July 27, 2001 at 12:38 pm
July 27, 2001 at 11:57 am
Viewing 15 posts - 39,721 through 39,735 (of 39,791 total)