SQL Server
The following table compares the maximum sizes and numbers of various objects defined in SQL Server 7.0, SQL Server 2000 and SQL Server 2005 databases or referenced in Transact-SQL statements. The table does not include Microsoft SQL Server 2000 Windows CE Edition and Microsoft SQL Server 2005 Windows CE Edition. The table has the technical [...]
Continue reading about SQL Server – Maximum Capacity Specifications Comparison
Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns.
It was interesting that value of the column was variable and something dynamic needed to be written. Following is quick script which separates one [...]
Continue reading about T-SQL Script to Divide One Column Data into Two Columns
Just a day before working on one of the projects, I had to take a backup of one database of 30 GB. My hard drive lacked sufficient space at that moment. Fortunately, I had two 16 GB USB Drives with me. Now, the question was how to take a backup in two equal sizes, each [...]
Continue reading about Split Backup Files while Backup and Restore SQL Server Database
We are in thought of only DBA’s can take backup using T-SQL, But anyone can take backup and restore backup very easily with the help of T-SQL. we can backup an entire database, transaction log, or one or more file or filegroups with the help of T-SQL.
Continue reading about Backup SQL Server database using T-SQL
Once you are started using SQL Server database for your application, you need to start taking database backups regularly. If it may be a development database or production database, you should take backups in a timely manner. Because if your information get loss, that brings you in loss. We cannot prevent the data loss due to disk failure, file corruption, code bugs, external factors, etc.
The best practice is to take database backup and store it in an external media like tape drive and keep it in a safe place. The easiest way to take database backup is by using SQL Server Management Studio (SSMS).
Continue reading about Backup SQL Server Database using SSMS
