Forum Replies Created

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

  • RE: Space reduction on restore

    run dbcc shrinkfile after restoring to reduce the size of the file.  Or you can run this prior to backing up.  Recommend shrinking in 500k or 1gig increments. 

  • RE: Sql Enterprise

    This happens most often when you have the view of your database set to 'task pad'.  Change view to to detail, then back to task pad and you should be...

  • RE: How to test that a linked server is running?

    I never see the value of @servererror or @@error, because as mssql_rules stated the TSQL batch exits.  Hard to believe that the only option is for the script to just...

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