Wednesday, March 27, 2013

Need to repair corrupt SQL server database

If you are working as a SQL server DBA from a long time then you will have encountered the SQL database corruption once in a while of your DBA life. Often corruption occurs due to power failure, sudden shutdown to the SQL server, hardware malfunction, virus attack, and many more. You can't access the database until repaired the database files. Additionally, there are several methods available to protect your database file from being corrupt. And it is equally related to your job. In the event...

Wednesday, February 13, 2013

FAQ: SQL Server Disaster Recovery

Q: Can I restore a SQL server database if I have data & log files? A: Yes, you can restore a SQL server database if your data file & log file is not corrupt. You can do this by attaching data & log files to the SQL server. Q: Can I restore a SQL server database if the data file is corrupt? A: No, you cannot restore a SQL server database with a corrupt data file. You need to restore your database from a good known backup. If you don't have a good backup of your database, there...

Sunday, January 27, 2013

Methods to Resolve SQL server Backup Error 3007

After upgrading SQL server database from SQL server 2000 to SQL server 2005. When you perform a full database backup of a SQL server 2005 database, you may got following error message on your system screen. Executing the query "Backup Database [ZZZ] TO [ZZZ] WITH NOFORMAT, NOINIT, NAME = N'ZZZ_backup_20060819040020', SKIP, REWIND, NOUNLOAD, STATS = 10 "failed with the following error: "The backup of the file or filegroup "sysft_ZZZ_FT" is not permitted because it is not online. BACKUP can...

Tuesday, October 30, 2012

Available Methods for Sending a Mail from SQL Server

!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } --> Are you looking for a method that enables you to send a mail from your SQL server? For you Microsoft SQL server offers a special feature that will enable you to send a mail from it. Earlier to SQL server 2000, it is known as SQL mail but with release of SQL Server 2005 it has been changed & the new name is database mail. Database mail is very useful for sending a mail from SQL server to end users as well as to database administrator....

Monday, July 30, 2012

Best solution for you when your database is suspect mode due to insufficient space in filegroup?

SQL server uses filegroup for grouping all the database objects & files, there are two types of SQL server filegroup, one is primary & another is user-defined. Primary filegroup contains the primary data file and all the pages for system table while any other filegroups that are specified with Create or Alter statements are known as user-defined filegroups. No any file can be member of more than one filegroup and log file is not a part of any filegroup. It is managed from data space. Note:...