Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 2,491 total)

  • RE: Anything else I can add to my Maint Plan?

    A final point... one thing missing from your maintenance plan is backups.  You are doing backups...?

    For most sites, a full daily backup is the best option.  Transaction log backups can...

  • RE: Anything else I can add to my Maint Plan?

    Running items 1 and 2 daily is probably overkill, and running item 3 at all is too often.

    1) Integrity check

    You need to balance your trust in the reliability of your...

  • RE: TempDB operations faster?

    There are some possible answers...

    It is possible that the #temp insert did not require and file growth for either the .mdf or .ldf files, but the insert into the local...

  • RE: Copying backup causes periodic failure

    It can be surprising how many times a tape backup needs a second tape, but this tape never gets mounted. The backp then hangs until someone notices it, often...

  • RE: SQL tool-- Patrol for MS SQL

    Knowing the memory usage for a database is not particularly useful.

    I have worked on DB2 for z/OS, where information of this type can be obtained. The really useful information...

  • RE: DTS & MSDB

    If you have custom DTS tasks, the backup and restore will affect the package definition, but will of course not include the custom DLL files. Restoring an old MSDB...

  • RE: Job failed with access denied on opening datafile

    Are you using a Job Output File (seen in the Advanced tab on thejob step)? We had a problem where the proxy account could not open this file, even...

  • RE: Query generates different exec plan!

    Why is the plan bad? Is it using parallelism? Have you tried turning this off?

    Also, if you have set SQL memory to the maximum on the box, you...

  • RE: Exclusive lock issue

    Your problem may be related to adjacent-key locking.

    When you do a insert or delete, SQL locks the adjacent key as well as the record you are processing. This is...

  • RE: Linked server and Windows Authentication

    My understanding of the theory is:

    1) You need to read what BOL says about this

    2) You need to be running W2K or above & SQL2K

    3) You need to talk to...

  • RE: dbo

    If user fred is a member of SYSADMIN, then any object they create will have a default owner of DBO. Also, fred can explicitly create an object with the...

  • RE: Transaction Log backup times increasing

    The main problem about increasing transaction log backup frequency to cope with peak loads is that you are imposing a high frequency of log backups when load is low.

    We backup...

  • RE: Bulk Insert ....

    You can also give your user DDLADMIN authority in TempDB. This will allow a user with only Bulkadmin authority to BCP (etc) into a temporary table.

    You then have the...

  • RE: QOD 30 Sep 2003

    Looks like Measure Up points are best.

    Working on the principle in the documentation that SQL7 can receive replicated data from SQL2K, but SQL2K cannot receive replicated data from SQL7, then...

  • RE: Linked Server to DB2

    You almost certainly need the DB2 ODBC driver. These are free in the DB2 install media. You will get better performance if you use a product called 'DB2...

Viewing 15 posts - 2,461 through 2,475 (of 2,491 total)