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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-09 : 08:19:02
|
| mian writes "Keep it short :We are running sql 2000 with log-shipping and taking full database backups every dayWe need to restore some data from backups the condition is , We just need last one week data not more then that . (full database is large about 200 GB)And there are no (STOPBEFOREMARK) etc , for back ups.Please can you help me , how I can do it .Thanks Kind RegardsMian fareed" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-09 : 09:28:12
|
| ???Not really sure what you mean.If you want just onw weeks worth of data then how would the server know what that means? (think about it)Whatever you do you have to start with a restore of a full backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Sql server Recovery