RESTORE VERIFYONLY FROM DISK = 'C:\temp\adventure.bak'

How to know whether our backup is succesfully taken?

Question Posted / sql dba

Answer Posted / sql dba

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure?

105

Explain “@@rowcount” and “@@error” in sql server?

1061

What is 3nf normalization?

973

Explain table valued parameters in sql server? Why tvp used?

1000

What is the maximum length of an alert name?

994

What does the on delete cascade option do?

997

Explain go command in sql server?

1008

Define model database?

957

How do database indexes work?

993

Does view occupy space?

919

List out the differences between the clustered index and non-clustered index in sql server?

987

How to set database to be single_user in ms sql server?

1007

How to locate and take substrings with charindex() and substring() functions?

992

What is factless fact table? : sql server analysis services, ssas

1006

What type of locking occurs during the snapshot generation? : sql server replication

1318