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 |
|
siva237
Starting Member
3 Posts |
 Posted - 2010-11-17 : 23:55:04
|
| I am taking backup of a online database and restoring it to a new database programatically using a stored procedure.All the back up and restore operation is successfull but observed that there is a data loss in few tables. There is no data loss if I manually take backup and restore it.I wonder why this is happening.Could anybody please look into this and expalin me the reasons casuing this problem.Expedite reply is highly appreciated..Below are the deatils regarding backup and restoreThe source database is online and in full recovery modeThe template of backup command isbackup database [databasename] from disk ='filepath'with noformat, noinit, name = 'datbasefilename', norewind, nounload, skip'v.siva prasad |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
siva237
Starting Member
3 Posts |
Posted - 2010-11-18 : 01:54:30
|
| Hi Tara, Thanks for your reply.I think I have found the issue.I am restoring database with file 1.I believe there are multiple full backup files that being appended and the file 1 might have old data.Thanks,SIva Prasadv.siva prasad |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Need Details regarding Backup and restore