Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AKSQL
  • Order by date
  1. AKSQL

    Big Master database afetr multiple restores.

    Wow. I apologise for even posting that result set to the forum. I was trying to rush home and did not even look at the table names. I did, in fact, run Bill's script (the most useful script I've seen in a long while -- thanks VERY much) against the master database and those tables do not...
  2. AKSQL

    Big Master database afetr multiple restores.

    OK - here are the results: Table Rows Reservd Data Index Unused Loc 825416 2033424K 2011128K 136K 22160K Lft 215448 281872K 275968K 64K 5840K Doc 844288 109184K 60184K 48952K 48K Wof 7162 12496K...
  3. AKSQL

    Big Master database afetr multiple restores.

    Awesome. Will do that this afternoon at the client site.
  4. AKSQL

    Big Master database afetr multiple restores.

    All: I have a remote/offsite server that drives my clients web site that seems to be having a problem. On a weekly basis they back up their working database, move the backup to the remote server, and restore it. This process, although still too manual, works quite well but for one problem...
  5. AKSQL

    Changing DB/Log Size.

    So in general this is a safe practise huh? Thanks much!
  6. AKSQL

    Changing DB/Log Size.

    So I have this DB that was set up quite a while ago (by someone else) with no maintenace plan in place. It was set up to automatically grow the file size of both the MDF and the LDF. Well... because the DB is reasonably active and there was no maintenace to truncate the logs they got...

Part and Inventory Search

Back
Top