Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: COPY DATABASE FROM REMOTE & PASTE IN LOCAL M/c

    "You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation."

    Seems a bit obvious. What are you using...

  • RE: copying backups from tape to tape

    Use Enterprise Manager to restore from tape to database. Backup from Database to disk. That solution would work for me, but I have a lot of backups and...

  • RE: Split log file or not?

    I've done a bit more research into how log files work and here's what I've found. The phyical logs are divided into many virtual logs that are created as...

  • RE: Split log file or not?

    There's lots of reasons why I need to allocate this space. The main one is that tempdb resides on this volume as well and if it runs out of...

  • RE: Split log file or not?

    Right, you said "strip" instead of "stripe" and that confused me a bit ;-), but this is indeed what I'm refering to.

  • RE: Split log file or not?

    Its not a matter of why its growing. We set our log files to a certain restricted size. This post is about whether to double the log file...

  • RE: Split log file or not?

    I'm not sure what you mean by "strip", but I'm refering to either adding another physical file to the log or increasing the size of the existing file. I.E....

  • RE: how to clear next run date

    'next run date' isn't something you can set in the scheduling. The jobs are already scheduled and created. Going back through and rescheduling them all (if this would even...

  • RE: how to clear next run date

    Just solved this. I generated a sql script of the jobs, deleted them and then ran the script to recreate the jobs.

  • RE: Query Analyzer Tricks

    Possibly someone has already commented on this (I can't find such), but the code snipet included in the article has some of its contents in less-than and greater-than signs which...

Viewing 10 posts - 1 through 10 (of 10 total)