Viewing 15 posts - 16 through 30 (of 40 total)
Of course, if your backup solution only writes to tape, and you forget to load the necessary tapes into the library, then your backups would fail for that evening.
November 30, 2005 at 3:45 pm
it is still asking for a log file. I think attaching a db w/o a log does not work, I have read past articles on it.
November 10, 2005 at 10:45 am
Jaya,
Triggers are usually very cpu intensive for the server, using the temp table is a much better solution for this, but keep on eye on your tempdb as the amount of your...
October 18, 2005 at 3:24 pm
This sounds like homework...LOL, do I get an A or you if I give you the correct answers?
Jules
October 18, 2005 at 3:18 pm
Donald,
If you have databases which are in the terabyte sizes, I would strongly suggest you buying SQL Litespeed. It is one of the best and fastest database backup softwares in...
October 11, 2005 at 9:42 am
Suresh,
Sounds to me like your MDAC 2.8 file got corrupted. Here is how this gets fixed:
go to regedit and delete the following entry:
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents
and reinstalling MDAC 2.8. - can be downloaded...
October 6, 2005 at 12:58 pm
Lisa,
You can ask the dba to give you read access, can't imagine you having to do this task everytime you want to query this db especially if you want refreshed...
October 5, 2005 at 12:59 pm
Mario,
Make sure you don't have table names which are duplicated. By this, I am saying if a user logs in with his windows authenticated username and he is dbo, he...
October 3, 2005 at 2:51 pm
Helen,
Usually when sql mail hangs, an error should come back, can you capture the error? Please give more details.
Jules
September 16, 2005 at 7:53 am
Please refer to this article for dts portability
http://www.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp
Jules
September 15, 2005 at 9:32 am
To answer Will's question about the root drive, you can backup the entire server using some very reliable backup programs, we use CA Brightstor for our development environment and Galaxy...
September 14, 2005 at 12:39 pm
LOL, Fortune 100 is the downsized version of Fortune 500. The other 400 are being outsourced.
On the serious side, you can and should archive that db to tape and store...
September 14, 2005 at 12:29 pm
Adrain,
When you execute the package manually, it uses your account (the one you use to log into your desktop/laptop). When you schedule it to run, it uses the service account from...
September 14, 2005 at 12:14 pm
Ian,
Looking back at past articles on this site, found an article that you might be interested in where you can disable foreign keys for snapshot replication. Here is the link:
September 13, 2005 at 9:05 am
Viewing 15 posts - 16 through 30 (of 40 total)