|
|
-
|
|
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database in SIMPLE RECOVERY mode. Yes , you can.
A few assumptions are made :
1) A Differential base exists
2) The Differential base is not a COPY_ONL...
|
|
-
|
|
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs to fill. This can lead to a Error 9002
In the Full Recovery mode , a Log Backup will delete the commited transaction log records. In the Simple Recovery , it’s after a......
|
|
-
|
|
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's as a nul device , anything “written” to it is discarded.Don’t confuse with the SQL reserved word NULL.
Before you run this statement , note that even as the file is not going anywhere , SQL Se......
|
|
-
|
|
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status.
The descriptions, courtesy of BOL are:
ONLINE - Database is available for access
RESTORING – One or more files are......
|
|
-
|
|
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered?
This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague.
My approach on DBCC CHE......
|
|
-
|
|
Some SQL Server DBA use offline, others Detach in moving databases. I use either, depending on the situation.
If replication is involved I use the Offline method. Others I use Detach\Attach.
Be mindful that both methods will attempt to close the database cleanly, and close the handles. And if usin......
|
|
-
|
|
This morning I found this error message in the TSM schedule logs
ANS1315W (RC15) Unexpected retry request. The server found an error while writing the data.
Preceded by
Waiting for TSM server
The conclusion was there were insufficient mount points or scratch tapes were not available
I......
|
|
-
|
|
Depending on the time available – I will normally commit a RESTORE VERIFY ONLY on a backup.
With the statement:
RESTORE VERIFYONLY FROM DISK = ‘E:\backuppath\mydb.bak’
I’m not advocating that RESTORE VERIFYONLY – will 100% guarantee that your database has full data......
|
|
-
|
|
There is a nightly backup | copy | & restore job as part of an ETL. Last night the job failed – with the error:
RESTORE detected an error on page (0:0) in database MYDB as read from the backup set.
The correlating message in the Event Viewer is:
The backup data at the end of "J:\mydriv......
|
|
-
|
|
After a restore on a database – I saw a (resticted user ) next to a database.
Solved the problem by:
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE mydatabase SET MULTI_USER
GO
Republished from http://www.sqlserver-dba.com.......
|
|