October 28, 2002 at 12:53 am
Greetings All
working out on restore plan for a dbserver having worth 50 databases.
backup plans is as follows:
systemdbs : master,msdb,model daily 4 am.
all user dbbackup(full) : 3 am daily
I have gathered following info :
1)sort order,collation seq etc..
using sp_helpsort..
2) comuptername,logins and users,
3) filegroups -- I have no other filegroups.other than default.
4) \mssql7\ dir location defaul : in c:\mssql7
mdf files location -- \mssql7\data
ldf file-- d:\dblogs
Prepared new system:
i have installed new sql server 7 (with sp4)
computer name is diff : as both the live Db server and this test one are in same network..
mssql7 dir is defaul.
i have No D: drive..-- so i want the logs should go in E: or c: itself..
sa password is blank.
auth mode: mixed.
sql service : running under : administrator account.
1)executed : rebuildm.exe specified correct sort order, etc..
2) restored master from latest backup set of 4.am of respective date.(successfull) no erros
5) resrt mssql service in mutiluser mode
sql server agent is stopped-- i can see all userdbs in Suspect mode in EM.
6) connect to sql server using QA-- mixed mode auth.
7) gave command
RESTORE DATABASE msdb FROM DISK='E:\DATA\databasebackup\systemdbs\msdb_db_200210270400.BAK'
THe OUTPUT I GET IS:
Processed 4960 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
Server: Msg 207, Level 16, State 1, Line 16
Invalid column name 'database_backup_lsn'.
Server: Msg 3009, Level 16, State 1, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Backup or restore operation successfully processed 4961 pages in 12.090 seconds
8) if i ignore this message , and continue to restore one of my user db
by giving with replace option in above same restore database command.e.g
RESTORE DATABASE localdb7 FROM DISK='E:\DATA\databasebackup\systemdbs\LocalDB7_db_200210270301.BAK' with replace , move 'localdb7_log' to 'c:\localdb7_log.ldf'
OUTPUT I GET IS:
Processed 512 pages for database 'localdb7', file 'LocalDB7_Data' on file 1.
Processed 1 pages for database 'localdb7', file 'LocalDB7_Log' on file 1.
Server: Msg 207, Level 16, State 1, Line 16
Invalid column name 'database_backup_lsn'.
Server: Msg 3009, Level 16, State 1, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
why is this error of history/detail updation is coming?
what all am i missing?
Pls help.
I need to finalize the plan and scripts by next 2 days
alos if anybody can help with some scripts of restore commands availble on net , i will customize this acc. to my needs..
Thanks a ton In advance.
Deepa
Backup or restore operation successfully processed 513 pages in 1.355 seconds (3.096 MB/sec).
October 28, 2002 at 4:35 am
Think you need the with move option to change where the log files go.
Andy
October 29, 2002 at 1:47 am
Hi Andy
I am already using with move option for logs.
Pls note that system databases are in default dir c;\mssql7\data only
The problems is that error--in msdb restore I think
RESTORE DATABASE msdb FROM DISK='E:\DATA\databasebackup\systemdbs\msdb_db_200210270400.BAK'
THe OUTPUT I GET IS:
Processed 4960 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
Server: Msg 207, Level 16, State 1, Line 16
Invalid column name 'database_backup_lsn'.
Server: Msg 3009, Level 16, State 1, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Backup or restore operation successfully processed 4961 pages in 12.090 seconds
The msdb backup file is also from same job as that of master backup that i have restored.
Do i need to restore model db also before msdb. There are not changes in the model Db(It is same as default)
Regards
Deepa
October 29, 2002 at 9:32 pm
Hi All
I have tried again and agian but failed.
But whatb i had was the one prev. day backup of msdb with me , I tried to restore it after master restoreof currentday. and it worked fine.
As much as i know msdb containg (backup jobs history etc..)etc.but now i am able to restore other Db's from latest set.
I read in one newsgroup saying that after u restore msdb SQL tries to update the history in msdb Db and taht may create a problem
Any help on this..
Also if I had restored one day older msdb and the restored all the User DB' from latest set, Then what all will i loose in the inetgrity..
Thanks &
Regards
Deepa
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply