Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Angry Unanswered: database shrinking

    The database log files a full, is shrinking the database safe?

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    what is shrinking the database ?
    Increase log file size / no. of log files / issue frequent commits
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Apr 2009
    Posts
    3
    i have another problem. we are running a snapshot replication on a sql server 2005, and recently it runs fine but just as its about to complete it halts and there is an error message:the process is running and is waiting for a response from the server.

    please help as this matter is very urgent.

  4. #4
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    Have you looked at reclaiming table space - if any have been deleted recently?

  5. #5
    Join Date
    Apr 2009
    Posts
    3

    database shrinking

    i don`t exactly understand, but some tables were indeed added recently.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •