New answers tagged sql-server-2008-r2
0
The SQL Server (SQLEXPRESS) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
It looks like a simple timeout. Windows is trying to start a lot of services at startup, and all those services can sometimes resource contention, making the startup of other services slow. A ...
1
There can be several reasons that cause Database Logical Consistency based I/O error:
Unexpected system shutdown/crash or forced shutdown
SQL administrator tries to query or modify SQL data
This article on SQL Server Central about logical consistency based error in SQL is amazingly written by SQL DBA.
-1
3 states a DB can be in
Online – all is well…happy path
Recovery pending – something is preventing the database from starting up
Suspect – transaction log is damaged
Can happen when a DB isn’t shut down properly or a rollback tries to read a corrupt page
Might have to rebuild transaction log
To Change database states,
ALTER DATABASE AdventureWorks2016 ...
0
Nonclustered indexes
Index can be dropped and recreated (NOT ALTER)
Can repair using REPAIR_REBUILD
Read the following references:
https://www.sqlservercentral.com/articles/recovering-data-from-corrupt-tables-using-non-clustered-indexes
https://www.stellarinfo.com/blog/handle-non-clustered-index-corruption-in-sql-database/
1
I have a special exception that I feel should be mentioned.
With SQL Server 2012 Enterprise and newer, adding a new NOT NULL column with a runtime constant is an online operation that is completed instantly and does not depend on the number of rows in the table.
More information about this is found in MSDN
I'll reproduce the important section
Starting ...
3
The reason the error occurs after varying numbers of rows are processed is because the conversion isn't done in a deterministic order. It depends on the execution plan.
And especially if the query is parallel (given the number of rows, I expect that it is), rows will be distributed differently across threads on each run and might hit the "Compute Scalar" ...
0
You have to add the object as a securable to the user, in the target database and then add the securable necessary and give update permission.
1
It's typically not necessary to use custom templates and installation for SQL Server on Azure Virtual Machines. The Azure Marketplace has an extensive collection of pre-configured templates for SQL Server on Azure Virtual Machines, which you can deploy through the Azure Portal or through Powershell. These are built and maintained by the SQL Server ...
0
Here you will find a template that shows how to create a SQL Server VM in Azure configure with 2 managed disks. One disk is for SQL Server data files and the other is for SQL Server backups. For more information, please click here.
1
It takes too long to update but when I do select on that updating table its completes very fast .
If the UPDATE query is taking a long time, but the SELECT part is fast when run on its own, then one possible reason is that the UPDATE is getting blocked due to incompatible locks being held by another session.
You can check for this while UPDATE query is ...
1
Did you try looking in the Reporting Services Configuration on the server in question?
https://social.msdn.microsoft.com/Forums/en-US/a856488b-fbcd-479e-9167-34ddf7ba3e83/how-do-i-find-out-if-ssrs-is-intregrated-or-native?forum=sqlreportingservices
0
Use bellow commands:
ALTER DATABASE database_name ONLINE
Or try this will also works.
RESTORE DATABASE WITH RECOVERY
10
In answer to your main question ("what is being backed up"), everything that is supposed to be 😀 More seriously, you can't use those time stamps as a sign of changes happening in the database files. SQL Server doesn't make any guarantees about how the modified date of database files will be changed or updated.
There is an interesting blog post here that ...
Top 50 recent answers are included
