Home Forums SQL Server 2008 SQL Server 2008 Administration Log not available error 9001 RE: Log not available error 9001

  • May 26, 2017 at 8:27 am

    #1944328

    gmodified - Friday, May 26, 2017 7:13 AM

    Hi there, I was going through replies and also struggling with 9001 error . I am trying to deploy transaction replication between 2016 SQL vm instances and every time publication is initialized i am getting 9001 on

    publication server : tempDB or publication DB
    or
    subscriber server:  tempDB

    drives show up as VMWARE virtual storage

    am I correct saying  this could this be possibly storage issue?

    Did you do what was recommended in a previous post (ie DBCC CHECKDB) on all of the DB's and chkdsk (if you can warrant the downtime)?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.