Click here to Skip to main content
15,921,660 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to union some table in a while loop to a table Pin
mhd.sbt1-May-13 5:04
mhd.sbt1-May-13 5:04 
AnswerRe: how to union some table in a while loop to a table Pin
Corporal Agarn1-May-13 4:20
professionalCorporal Agarn1-May-13 4:20 
GeneralRe: how to union some table in a while loop to a table Pin
mhd.sbt1-May-13 4:26
mhd.sbt1-May-13 4:26 
GeneralRe: how to union some table in a while loop to a table Pin
Eddy Vluggen1-May-13 4:59
professionalEddy Vluggen1-May-13 4:59 
QuestionSSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 19:47
Richard.Berry10030-Apr-13 19:47 
AnswerRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 21:56
professionalGuyThiebaut30-Apr-13 21:56 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 22:16
Richard.Berry10030-Apr-13 22:16 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 22:43
professionalGuyThiebaut30-Apr-13 22:43 
I restore the backup to a test system(so yes a duplicate database) then I test a series of .Net apps on the restored data as a sort of sniff test.

SQL Server is 'generally' good at telling you if a backup restored with corruption - you could run a select query on the major tables as a sniff test, just to ensure that what comes back looks ok.

As a DBA you want to make sure that when the SHTF you can get the systems back to working within an agreed SLA(which is another point - make sure that you have an agreed SLA on how long a restore of a broken system will take and double the time you think it will take you, I can't stress how important this is because when things go wrong people behave irrationally and you need to be able to hold up that piece of paper to give yourself some space, in order to get on with fixing the systems).

A few useful sites worth reading.
Backups[^]
Validating a backup[^](if you are not subscribed it is well worth joining this site)
Database integrity[^]

I would strongly recommend an image backup every month with daily incremental image backups - disk space is cheap and rebuilding systems is expensive.

Another tip - if you are not running this all on a virtual machine, ensure that the SQL Server install is on a different disk to the software accessing it(this will further ensure its integrity and speed up access).
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 23:18
Richard.Berry10030-Apr-13 23:18 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 23:34
professionalGuyThiebaut30-Apr-13 23:34 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 0:10
Richard.Berry1001-May-13 0:10 
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 1:57
Ravikiran72p30-Apr-13 1:57 
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 9:49
professionalEddy Vluggen30-Apr-13 9:49 
AnswerRe: Generic column mapping Pin
Mycroft Holmes30-Apr-13 13:56
professionalMycroft Holmes30-Apr-13 13:56 
AnswerRe: Generic column mapping Pin
GuyThiebaut30-Apr-13 21:49
professionalGuyThiebaut30-Apr-13 21:49 
AnswerRe: Generic column mapping Pin
jschell1-May-13 8:34
jschell1-May-13 8:34 
QuestionMariaDB on Linux Pin
mbadi27-Apr-13 10:57
mbadi27-Apr-13 10:57 
QuestionError on SQL server join Pin
DeveloperLife201526-Apr-13 13:12
DeveloperLife201526-Apr-13 13:12 
AnswerRe: Error on SQL server join Pin
s_magus26-Apr-13 17:41
s_magus26-Apr-13 17:41 
AnswerRe: Error on SQL server join Pin
AANIL DHAKAD8-May-13 19:17
AANIL DHAKAD8-May-13 19:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC26-Apr-13 12:37
PrissySC26-Apr-13 12:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes26-Apr-13 13:01
professionalMycroft Holmes26-Apr-13 13:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC27-Apr-13 1:39
PrissySC27-Apr-13 1:39 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
jschell27-Apr-13 11:32
jschell27-Apr-13 11:32 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC28-Apr-13 1:41
PrissySC28-Apr-13 1:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.