Forum Replies Created

Viewing 15 posts - 16 through 30 (of 40 total)

  • RE: Problem with tape backups

    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.

  • RE: sp_attach_db problem

    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.

  • RE: Performance in Triggers

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

  • RE: SQL/DATABASE help!!

    This sounds like homework...LOL, do I get an A or you if I give you the correct answers?

    Jules

  • RE: How does everyone backup?

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

  • RE: microsoft odbc sql server driver Communication link failure

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

  • RE: Query a backup file?

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

  • RE: Index already exists - EM bug?

    Yes Rudy, you are correct!

    Jules

  • RE: Index already exists - EM bug?

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

  • RE: SQL mail hangs

    Helen,

    Usually when sql mail hangs, an error should come back, can you capture the error?  Please give more details.

    Jules

  • RE: DTS server name

    Please refer to this article for dts portability

    http://www.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp

     

    Jules

  • RE: How does everyone backup?

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

  • RE: Need to archive data off the server

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

  • RE: Scheduling DTS Package for none sysadmin users

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

  • RE: Snapshot Repl. Failing with Foreign Key Constraints

    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:

Viewing 15 posts - 16 through 30 (of 40 total)