Forum Replies Created

Viewing 4 posts - 31 through 34 (of 34 total)

  • RE: Named Instances

    It's possible that antivirus programm on your machine may accessing it.

    Also make sure that you have detached the database properly. Check for the same using sp_helpdb.

  • RE: Shrinking Database file

    Jeff,

    That's why you are champion !!! 🙂

    But I think one can use Truncate_only with proper planning...

  • RE: Shrinking Database file

    If your database is not configured for Replication or Logshipping you can use following command to shrink your databse log file to death:

    backup log with truncate_only

    dbcc shrinkfile...

  • RE: Log Shipping

    You can also use SSIS for transferring Jobs and Logins from your primary server to secondary server.

Viewing 4 posts - 31 through 34 (of 34 total)