Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 1,319 total)

  • RE: Backup can not be performed on database

    To reiterate various comments already made in this thread: If the database is sent to simple recovery mode, no you cannot backup transaction logs. With respect to Onepoint (if that's...

  • RE: Disk space full after deleting the records

    Are you trying to delete all records on a table? If so, truncate table has low overhead with respect to logging. You can delete in small rowsets and backup the...

  • RE: RTF decoder

    Did you check out this thread (same forum, a little bit older)? I don't use rtf within SQL but seems to be some useful items.

    http://www.sqlservercentral.com/Forums/Topic220973-23-1.aspx

  • RE: Out of ideas

    Maybe I misunderstood something here. I thought you were profiling your user community as when you run these same queries in QA, there are no issues. What exactly are you...

  • RE: Out of ideas

    What kind of connection do they have to the database server? Bandwidth can be a killer, especially depending on the size of the resultset being returned.

  • RE: Consolidating Backup Maintenance Plans to a central server.

    Just my 2 cents but as Ola stated, you now would have a single point of failure and need to scramble to restart/create backup jobs elsewhere, whether another single machine...

  • RE: A Worthwhile Goal

    Quality and consistency for me today!. I recently started a new job. My old company, everything was new and was built quickly but consistently (not always quality) so anyone could...

  • RE: Stored Procedure performance hit

    It appears the reboot did the trick. Strange indeed. I should have stated in my original post that this is running on VMWare and ESX server, which was installed in...

  • RE: TRANSACTION LOG BACKUP BIG

    Good point, didn't even think about that option. And it saves disk space!

  • RE: TRANSACTION LOG BACKUP BIG

    Why not take your full backup after your index rebuild and log backup? Then, if you do need to recover, simply restore the full (and potentially other, smaller t-logs) and...

  • RE: Scripting Jobs

    Brain cramp!:blush: Right click on the job and generate SQL scripts.

  • RE: TRANSACTION LOG BACKUP BIG

    What exactly are you trying to accomplish? The maintenance jobs grow the t-log as needed. Are you simply trying to save disk space? I'd continue doing things the way you...

  • RE: Knowledge Transition for DBA

    Steve Jones - Editor (5/9/2008)


    Good advice above from Tom.

    I think backups and security are most important, but it's good to get the other information listed above.

    Steve, it's Terry, not Tom....

  • RE: Urgent help required

    Darryl, be aware that if you restricted your log to 2GB and the log needs to grow beyond that, all processing will stop until someone manually increases the size or...

  • RE: SQL SERVER AGENT

    I've never seen the SQL Server Agent stop because it has no work to do. Most of my scheduled jobs run overnight and the agent never shuts down. Check the...

Viewing 15 posts - 1,141 through 1,155 (of 1,319 total)