I had previously written article on SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial. Microsoft has come up with white paper regarding same Best Practice Analyzer. In the new R2 version the SQL BPA introduces advanced capabilities in conjunction with the PowerShell architecture and also raises the bar for prerequisites and cross dependencies.
Microsoft has just released white paper which discuses the best practices to use Best Practices Analyzer. This white paper covers very important aspects of the tools. They talk about Installations, Usage and Troubleshooting. Additionally this white paper covers Engine Rules and Powershell methodology. I suggest everybody who is using this tool to read this white paper.
Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper
Reference: Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
Read on ‘E:\DSDB\DSDB_db_201009070100.BAK’ failed, status = 23. See the SQL Server error log for more details.
RESTORE DATABASE is terminating abnormally.
any help?
I’m having the same problem “status=23″…