i get from backupset but how to find in scheduled jobs ?Is there any way to find through T-sql

Thank you, its clear now why a table of a column can contain only one IDENTITY property.

i got it from another form .

ITs RESTORE VERIFYONLY options with checksum i can validate the backup files

How can we create an optimistic maintenance plan for the below mentioned scenario - ?

1. i do have one 1 TB of Database size

2. 500 GB of Transaction log file

3....

Thanks,

How can we create an optimistic maintenance plan for the below mentioned scenario -

1. i do have one 1 TB of Database size

2. 500 GB of Transaction log file

3....

Thanks David,

one more assist you have specified - [ Do it only for exceptional reasons ]

Can you specify the exceptional reasons or if anybody has faced such situation.

I need...

I want to understand the mentioned topics in details theoretically or with examples , from where can i get ?

continuing the following,

can anybody share which book to refer or links for the following topics.

Here also i need book which specifies the internal working in depth knowledge is shared

Topics:

1.Backup &...

Hi Gila,

thanks for your assist, before i was working 2 yrs in mysql as jr.dba, now my present job is in SQL SERVER 2008.

i have referred msdn for basics...

Thanks John, i will go for the sql server internals. thanks for assisting me.