'load database' Tag

  • across platform ASE load - instructions

    July 22, 2009

    run dbcc checkdb and dbcc checkalloc
    put database in single-user mode
    execute sp_flushstats
    … wait some time (approx. 1 min)
    execute checkpoint
    dump database
    load databases on target db
    execute sp_post_xpload - it ensures, that all indexes are correct
    execute sp_indsuspect - findout corrupted indexes

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org