Friday, November 26, 2010

SQL 2005 Self-Paced Lab from PSS

If you still using SQL 2005, or want to learn the below topic, go to download PSS Service Center Lab 2005

Blocking and Deadlocking
In these labs you will use SQLDiag, SQL Profiler, and various DMVs to solve blocking and deadlocking problems.

Performance
In these labs you will use SQLDiag, SQL Profiler, showplan, and ReadTrace to solve various query performance problems.

Debugging
In these labs you will learn more about debugging tools used by the PSS team such as SQLDumper and Windows Debugging Tools to solve problems like a crash of SQL Server.

Server and Data Recovery
In these labs you will learn to how to solve various server and database offline problems.

Friday, November 12, 2010

Netvault - Failed to Open file exclusions file

I using Netvault Backup to backup my database.
The Netvault backup has an option where we can exclude file with certain extention

I add a file with extention list want to exclude in backup

When Netvault start backup, it give this message :
Backup completed with warnings

I check Netvault log and found this
A problem occurred initializing items to exclude from the backup: "Failed to open file exclusions file 'c:\file\exclude.txt"


A problem occurred initializing items to exclude from the backup: "File exclusions file 'c:\file\exclude.txt" is not a valid Unicode file

Solve with :
Open and save exclude.txt as unicode file and backup successful without warning