EugeneChiang.com

Create SQL Job Script

Go to … SSMS -> Specific Database Server -> SQL Server Agent -> Jobs -> Specific Job -> Script Job as Note: Make sure to change the schedule quid id if you replicate from a previous job.

All Table Count in Database

Moving Large Database Backup File

Tips for moving large backup file. Create multiple backup files instead of one large backup file. Use file compression programs like WinZip to compress backup file. Consider trimming the data in the database before creating the backup file. Create database and data from scripts. 7zip You can also use software like 7zip to compress and... » read more

Unable to start SQL Server Service

Problem: Unable to start SQL Server Service. Check Windows Logs in “Event Viewer”. Cause: FCB::Open failed: Could not open file C:\MSSQL\tempdb.mdf for file number 1. OS error: 3(The system cannot find the path specified.). Problem with tempdb. Unable to find tempdb drive.

Reconfigure SQL Server Reporting Services After Server Name Change

Error 1: The service is not available. Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details. Error 2: The report server isn’t configured properly. Contact your system... » read more

Change Server Name for SQL Server Machine

As you may know, the internal SQL Server name is based on the physical server name, but changing the physical server name does not update the metadata within SQL Server. When connecting to SQL Server, we use the physical server name for the default instance and physical server name\INSTANCE Name for a named instance. If you change the physical server name, there is... » read more

Restore Database from Multiple Backup Files

You only have to specify MOVE if you want to move the file to another location. If you are restoring to the same drive and location, you don’t have to specify MOVE. Note: All backup files must be included in order to backup the database. Order of backup files does not matter. Renaming backup files... » read more

Estimate Database Backup and Restore Progress

Sources:

Database Corruption SQL Errors – 823, 824, 825

These alerts are focussed on successful access(IO) to the hard drives that SQL Server is using. If there are  any errors when reading or writing to the drives then one of these errors will be returned. Having the alerts on these errors means that any IO issues will be brought to the DBAs attention well... » read more

SQL Error 1205 Transaction was deadlocked

Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Deadlock occurs when two users have locks on separate objects and each user wants a lock on the other’s object. When this happens, SQL Server ends the deadlock by automatically choosing... » read more