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 |
|
rajesh_alluri
Starting Member
2 Posts |
 Posted - 2005-06-22 : 12:00:02
|
| Hi there I am preparing for MCDBAI am practicing to backup transaction log from northwind database.But the option box transaction log back is disabled.Thanks in advance.RegardsRajeshRegardsRajesh |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-22 : 13:17:56
|
| change your recovery mode to Full.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
rajesh_alluri
Starting Member
2 Posts |
Posted - 2007-08-01 : 20:58:43
|
| I am working on project mobileapples.How do I optimise my queries in MSSQL 2005RegardsRajesh |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-01 : 23:08:34
|
| Check execution plan, use proper index, ... |
|
|
|
|
|
|
Backup Transaction log