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 |
|
nardionline
Starting Member
7 Posts |
 Posted - 2008-08-22 : 11:05:51
|
| I have installed sql server 2000 on my server .i have an old back up.i have restored this back up on the back up server. i have made some changes ldf file of my database and now i want to import only the data to my old back up.I want to overwrite the data though!How can i do that.Is it possible?Regards!Regards Nardi! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 11:14:52
|
| What do you mean? Back again to capture all changes. |
 |
|
|
nardionline
Starting Member
7 Posts |
Posted - 2008-08-22 : 11:17:44
|
| I need to overwrite the old data and write the new data in the old backup!Regards!Regards Nardi! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 11:25:46
|
| I mean take Transactional log backup to capture the changes. While Restoring You can restore your full backup with Norecovery option and Tran log backup with Recovery option. |
|
|
|
nardionline
Starting Member
7 Posts |
Posted - 2008-08-22 : 11:32:10
|
| I don't understand because i am novice in sql server!Trasanctional file is corrupted!could explin this in a few steps!So i can make it step by stepRegards Nardi! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 11:37:51
|
| You have Full backup : (You haven't taken backup since then)So you restored your database and after that you made a change. So you take transaction log backup to capture all changes from your full backup. So in novice term, you need two backups to have your database upto date. |
|
|
|
nardionline
Starting Member
7 Posts |
Posted - 2008-08-22 : 11:43:36
|
| can i make a back to the current database and then make all the proces?Regards Nardi! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 11:47:27
|
| Didn't get it??? Explain clearly. |
|
|
|
nardionline
Starting Member
7 Posts |
Posted - 2008-08-22 : 11:53:36
|
| i just want to import changes from one server to another.I need to import them because the current database is corrupted and don't work very well.the back up server uses a back up database (old database).i need to import changes from the corrupted database (ldf file corrupted only) to the the backup server .you said that i need two backups to make this happen.i said maybe i should back up the current database so i can have two backups if i got it right.Regards Nardi! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 14:36:42
|
| How did you know it is corrupted? Did you run CheckDB after restoring? You will have to explain clearly. |
|
|
|
|
|
|
importing data only