20:02:37.59 spid8ğCB: Open failed: Could not open device C:\Program Files\Microsoft SQL Server/mssql/data/msdbdata.mdf for virtual device number (VDN) 1. 20:02:37.37 spid8 udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL data msdbdata.mdf. 20:02:37.37 spid10 Starting up database 'Northwind'. A file is missing: 20:02:37.37 spid8 Starting up database 'msdb'. *//*sql server was stopped and startedfrom the errorlog, we see that MSDB will not come up. Script use mastergo backup database msdb to full_backup with initgo /*Processed 1496 pages for database 'msdb', file 'MSDBData' on file 1.Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.BACKUP DATABASE successfully processed 1497 pages in 13,361 seconds (0.917 MB/sec). Server: Msg 3708, Level 16, State 6, Line 1Cannot drop the database.
The default recovery model for msdb is simple.
0 kommentar(er)
