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, March 27, 2013
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:...
Subscribe to:
Posts (Atom)