Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-06-10 : 10:42:41
|
| Hi All,1)how can we find the datafile and log file of a backup without using GUI...2)when can the data go to datafile from logfile which database in simple recovery mode?3) what is the necessity of logfile when the database is in simple recovery mode?4) what is active log and in active log?5) is it possible to merge 2 or 3 full backups as a single full backup?these are questions from IBM today. can you just give your experience here.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-10 : 12:06:22
|
1)restore filelistonlyfrom disk='H:\path_to_your_dump\filename.bak'2)When transaction is completed3)To ensure the possibility of a rollback when it is required for a transaction4)active logs are log records for not committed or rolled back transactions.inactive logs are log records related with earlier committed or rolled backed transactions.5)I don't know
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
how to find datafile and logfile using backup