Article 3.6.1I : How to solve database startup error ?
1- If below mention error is coming in database
2019-06-03 11:43:07.64 spid4092 Recovery completed for database ELNet5Data58 (database ID 63) in 2 second(s) (analysis 1274 ms, redo 0 ms, undo 811 ms.) This is an informational message only. No user action is required.
2019-06-03 11:43:20.08 spid828 Starting up database 'ELNet5Data63'.
2019-06-03 11:43:39.69 spid4102 Starting up database 'ELNet5Data58'.
2019-06-03 11:43:59.23 spid4107 Starting up database 'ELNet5Data59'.
2019-06-03 11:44:00.09 spid4109 Starting up database 'ELNet5Data63'.
2019-06-03 11:44:09.40 spid4109 Recovery completed for database ELNet5Data63 (database ID 68) in 4 second(s) (analysis 1985 ms, redo 0 ms, undo 2589 ms.) This is an informational message only. No user action is required
2- why is the error coming?
It is happening because Auto close setting of database is On. So if database is not in use. it is in close condition and when it will get the response to add some data. it will start opening & giving above error log.
3- IF the amount of data is not too much then there is a no issue but if the size of database is large. Then it is taking time to open database & recovery. In that case sql taking time to respond.
4- How to avoid this error.
1st- use below query to put database always in on mode.
ALTER DATABASE [SQLAuthority] SET AUTO_CLOSE OFF WITH NO_WAIT
GO
2nd-
a. Open sql & connect DB
b. select DB & right click
c. open properties
d. use below image
Related Articles
Article 3.6.1AQ : SQL INSTALLATION ERROR Database Engine startup handle
ERROR WHILE INSTALLING SQL EXPRESS EDITION Could not find the Database Engine startup handle. SOLUTION: Reinstall the SQL with new setup of any versions by downloading, which will resolve the issue in installation failure.Article 3.6.1L : How to solve "Value cannot be null. Parameter name: viewinfo" when expanding database.
When expanding database its showing error of " Value cannot be null Parameter name: viewinfo (Microsoft.SqlServer.Management.SqlStudio.Explorer) Kindly follow the below steps: Open Run file using windows key + R Type %Temp% then Hit Enter Key. So ...Article 3.6.1W : How to solve Incorrect syntax near 's' when restoring DB.
When restoring DB, Incorrect syntax near 's' error will popup. To solve this, follow the below steps. Step 1 : Go to DB restore page (Select DB -> right click -> select Tasks -> Restore -> Database). Step 2 : Click options. Step 3 : Enable overwrite ...Article 3.1.2J : How to solve Elnet Email "5.5.1 Authentication" error ?
When you face below error when configuring Email alert. Follow the steps to make it right. Step 1 : In Gmail, go to My account -> Security -> Low secure apps -> Turn ON. Once low secure apps is enabled, Email will send from that account. FYI - Make ...Article 3.6.1M : Data is not logging for few meters - Why & How to solve it?
Step 1 : First Check SQL database (i.e whether it is connected/online or not). Step 2 :If only few meters data are not logging, then database might be corrupted. Step 3 : Create a new database with a same name (delete/rename previous one), Step 4 : ...