hai!
i have a database which crashed recently(26th sep 2007).my last backup is on 14 sep 2007.i have restored database after two days.Now i have a database (old) with data upto 14sep 2007 and from 26sep to till date.(data from 14sep to 26sep missing).I restored database on 28th with a new database name which has data upto 26th sep 2007.how to attach these two databases to a single database to have data from beginning to tilldate.
please help in this regard.in the future, if you want to be able to recover all of your data you should place your databases in full recovery, take full and transaction logs back ups, have you mdfs and ldfs on seperate drives and make sure your your backups are stored on a tape drive or another server and maybe keep a copy off site.
as for your current situation, it sounds like you are going to have to stitch this one together by copying your tables from one database into the tables of the database you want to hold all of your data.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment