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