Here are the Step that are followed by the SQL Server Restore Process
RestoreDatabase: Database MANI_TESTDB2000
RestoreDatabase: Streams open
RestoreDatabase: Configuration section loaded
Starting up database ‘MANI_TESTDB2000′.
RestoreDatabase: Planning completed
RestoreDatabase: Creating files
RestoreDatabase: File creation completed
RestoreDatabase: Restoring backup set
RestoreDatabase: Backup set restored
Starting up database ‘MANI_TESTDB2000′.
Bypassing recovery for database ‘MANI_TESTDB2000′ because it is marked IN LOAD.
Starting up database ‘MANI_TESTDB2000′.
Bypassing recovery for database ‘MANI_TESTDB2000′ because it is marked IN LOAD.
Recovery is checkpointing database ‘MANI_TESTDB2000′ (5)
RestoreDatabase: Done with fixups
Starting up database ‘MANI_TESTDB2000′.
Analysis of database ‘MANI_TESTDB2000′ (5) is 100% complete (approximately 0 more seconds)
RestoreDatabase: Writing history records
Database restored: Database: MANI_TESTDB2000, creation date(time): 2004/11/13(13:37:49), first LSN: 146029:1710:1, last LSN: 146029:6464:1, number of dump MANI_TESTDB2000ices: 1, MANI_TESTDB2000ice information: (FILE=1, TYPE=DISK: {‘E:\MSSQL7\BACKUP\DB.Backups\Prod_db_200901020045.BAK’}).
RestoreDatabase: Finished
These are all the crucial Steps the restore process taken to restore a database and then initialized it. this information is stored as usual in SQL SERVER ERROR LOG.
This was for SQL 2000 version: use can use DBCC TRACEON(3004, 3605, -1) to tun on the database restore logging into the SQL Server Error Log and use DBCC TRACEOFF(3004, 3605, -1) to turn the logging process off.
Loading ...