Viewing 15 posts - 39,646 through 39,660 (of 39,709 total)
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
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...
July 27, 2001 at 11:48 am
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...
July 26, 2001 at 9:05 am
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...
July 26, 2001 at 9:01 am
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...
July 26, 2001 at 8:42 am
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...
July 24, 2001 at 8:39 pm
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...
July 24, 2001 at 4:06 pm
Your post doesn't make much sense.
Your system DSN specifies the type of authentication (NT Auth or SQL Auth). If you are using NT Auth, then the authentication will actually occur...
July 24, 2001 at 3:14 pm
Viewing 15 posts - 39,646 through 39,660 (of 39,709 total)