ورود

View Full Version : چطوری بک آپ sql server 2008 رو روی sql server 2012 برگردونم ؟



snbb000
یک شنبه 06 بهمن 1392, 15:24 عصر
سلام
دوستان من بک آپ دیتا بیس sql server 2008 دارم میخوام روی sql server 2012 برگرذونم ارور میده

Msg 4214, Level 16, State 1, Line 2
BACKUP LOG cannot be performed because there is no current database backup.
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.
7 percent processed.
12 percent processed.
17 percent processed.
21 percent processed.
26 percent processed.
31 percent processed.
36 percent processed.
41 percent processed.
46 percent processed.
51 percent processed.
55 percent processed.
60 percent processed.
65 percent processed.
70 percent processed.
75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
97 percent processed.
100 percent processed.
Processed 328 pages for database 'PS', file 'PS' on file 3.
Processed 1 pages for database 'PS', file 'PS_log' on file 3.
Converting database 'PS' from version 661 to the current version 706.
....
Database 'PS' running the upgrade step from version 698 to version 699.
Database 'PS' running the upgrade step from version 699 to version 700.
Database PS' running the upgrade step from version 700 to version 701.
Database 'PS' running the upgrade step from version 701 to version 702.
Database 'PS' running the upgrade step from version 702 to version 703.
Database 'PS' running the upgrade step from version 703 to version 704.
Database 'PS' running the upgrade step from version 704 to version 705.
Database 'PS' running the upgrade step from version 705 to version 706.
RESTORE DATABASE successfully processed 329 pages in 0.393 seconds (6.536 MB/sec).


چکار کنم ؟
لطفا اگر کسی میتونه کمک کنه دریغ نکنه .
ممنون

snbb000
پنج شنبه 17 بهمن 1392, 21:51 عصر
کسی نمیتونه راهنماییم کنه ؟

espootin
پنج شنبه 17 بهمن 1392, 22:54 عصر
سلام
دوستان من بک آپ دیتا بیس sql server 2008 دارم میخوام روی sql server 2012 برگرذونم ارور میده

Msg 4214, Level 16, State 1, Line 2
BACKUP LOG cannot be performed because there is no current database backup.
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.
7 percent processed.
12 percent processed.
17 percent processed.
21 percent processed.
26 percent processed.
31 percent processed.
36 percent processed.
41 percent processed.
46 percent processed.
51 percent processed.
55 percent processed.
60 percent processed.
65 percent processed.
70 percent processed.
75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
97 percent processed.
100 percent processed.
Processed 328 pages for database 'PS', file 'PS' on file 3.
Processed 1 pages for database 'PS', file 'PS_log' on file 3.
Converting database 'PS' from version 661 to the current version 706.
....
Database 'PS' running the upgrade step from version 698 to version 699.
Database 'PS' running the upgrade step from version 699 to version 700.
Database PS' running the upgrade step from version 700 to version 701.
Database 'PS' running the upgrade step from version 701 to version 702.
Database 'PS' running the upgrade step from version 702 to version 703.
Database 'PS' running the upgrade step from version 703 to version 704.
Database 'PS' running the upgrade step from version 704 to version 705.
Database 'PS' running the upgrade step from version 705 to version 706.
RESTORE DATABASE successfully processed 329 pages in 0.393 seconds (6.536 MB/sec).


چکار کنم ؟
لطفا اگر کسی میتونه کمک کنه دریغ نکنه .
ممنون


با سلام.

طبق این خروجی که شما گذاشته اید،‌اینطور به نظر میرسد که Restore بدرستی انجام شده است(طبق خط آخر).

اما اگر خط ۲ و ۴ رو میگید : ابتدا می خواسته از log بکاپ بگیره که از اونجایی که نبوده نتونسته بگیره و بکاپ لوگ نا موفق بوده ، که ایرادی هم نداره.