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 |
|
christiangodi
Starting Member
3 Posts |
 Posted - 2010-05-26 : 22:02:48
|
| Hi, we are migrating a sites database that was on sql server 2000 to sql server 2005. now i took a backup of the database in the SQL 2000 and it has given me a set of backup files..1. CASELOG_db_201001120200.BAK2. CASELOG_db_201001130200.BAK3. CASELOG_db_201001140200.BAK4. CASELOG_db_201001150200.BAK and some more like this.when i'm trying to restore on SQL 2005 using Management studio..i was able to select only one of the above files...so do i have to restore all the backup files one after the other the same way as i do with the first backup file...how do i do this restore? your help is appreciated. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-27 : 01:51:04
|
Just take the file with the highest date.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-27 : 04:43:11
|
| ... assuming they are FULL backups and not LOG backups.Presumably you don't want a January one?!!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230Refers to SQL 2008, but pretty much all of it relevant to SQL 2005Why not upgrade to SQL 2008? You will buy yourself more time before you have to upgrade again ... and do all the same testing works yet again ... |
|
|
|
rajendradhakal
Starting Member
11 Posts |
Posted - 2010-06-02 : 00:58:42
|
| I'm also facing the problems of restoring complete database using programming. I've already taken a backup file using store procedures of sql server. Which basckup on text file. I want to restore that backup file on same database. I'm facing the problem on it. you have had backup on .bak file.Rajendra DhakalDO good, Wish Good and so on |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-02 : 01:35:37
|
In MS SQL Server a backup file is a backup file.Then file is usually named as a .bak file.If you have a real .txt file with readable content then it is not backup file.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Restoring sql server 2000 database backup on 2005