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 26, 2010
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
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
Subscribe to:
Posts (Atom)