By default, the full-text service is set to "Manual" and starts when required (initiated by the SQL Server service I believe). Try running a full-text query and see if that...

RECOVERY PENDING is not...

There is no way to estimate how long beforehand, there are too many variables involved (disk speed, IO performance, load on the server, how many VLFs in the log file...

• This reply was modified 4 years, 10 months ago by  HandyD. Reason: meant to say "NOT" 100% accurate

Can you script out the action from the GUI and see if it is running the same commands your script was running?

Is it possible to restore a differiential backup file from the SQL Server 2012 Primary Database to the SQL Server 2017 database?

Is it possible to restore the log backup...

Check out this article by Pinal Dave. Basically, someone has manually changed max worker threads from 0 to 2048. If that person was kind enough to document when and...

The problem is your procedure is returning a result set, which can't be used to populate a variable. You need to use an OUTPUT variable instead, which can then...

Is there an option for a profile to be associated with more than one login, and vice versa? I'm guessing no, in which case I am curious why you would...

I'm assuming by "SQL Server upgrade" you mean migrating to a new instance on a newer version, as an inline upgrade wouldn't affect server name. With that assumption, the solution...

SSRS configuration is not managed via SSMS. You can connect to SSRS instances via SSMS and view some basic stuff; jobs, security and shared schedules, but any configuration beyond this...

Depending the level of monitoring you want, you can setup some simple state monitoring for mirrors using the instructions here: https://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/

If you want more comprehensive monitoring of mirroring health...

1) Is it possible to log ship from a SQL Server 2017 database to a SQL Server 2012 database?

No, you cannot restore a backup to a lower version. If you...

Try this:

SELECT [Volume],

[Timestamp],

[TotalSize_GB],

[Available_GB],

LAG([Available_GB]) OVER (ORDER BY TIMESTAMP) AS [Previous_Available_GB]

[Available_GB]-LAG([Available_GB]) OVER (ORDER BY TIMESTAMP) AS [Difference]

FROM DiskSpaceInfo

Effectively, not granting any SELECT permissions is the same as explicitly denying those permissions, except when the user has been granted permission at another level. For example, you can GRANT...