Is any additional information mentioned in the Redgate Backup log file (\Red Gate\SQL Backup\Log\<instance name>)

This same situation is described by another poster. See thread Suspect data in SQL tables.

You can find most of these values in the [master].[sys].[master_files] table. The size value is in PAGE, so you'll need to divide by 128 to convert to MBs.

If you need...

GA_SQL (11/2/2016)

---

Adding space to the Database , when the db is 75% full

here i done some script for finding free space

select

s.FILEID AS...

I myself noticed slow navigation/scrolling in SSMS when I have large scripts open. Eventually I modified IntelliSense and AutoRecovery settings to smaller values. That improved the performance quite a bit.

Instead of an alert on "growing" of the LOG file, you can create an alert on the usage of the log file: 'SQLServer:Databases|Percent Log Used|tempdb|>|99'. Such alert will fire when...

Duplicate post, please respond only to the other thread Redshift Script.

kj700098 39683 (10/31/2016)

---

hi

<snip>...

If I type VALUES (1, '1 Value', 18,2) I got an error, because I have used comma which is normal in most countries in europe.

So how can I...

Resolve the name of the client machine [CLIENT: 194.83.78.12] -- use "ping -a 194.83.78.12" on a command prompt -- and look on that machine for any processes/jobs/applications that connect to...

The picture of the services shows the SQL Server service is not running (although the startup is manual). In the other picture the message indicates the service is started, but...

Take a look at Kenneth Fishers free script session on sqlstudies.com[/url]. There you'll find scripts to script out instance- and database level permissions. You can run the generated commands on...

If SQL Server Configuration Manager only list the Reporting Server service, it looks like the SQL Server engine is not installed on that machine. The functionality of configuration manager has...

You'll also need to use parameter "@query = " when calling the sp_send_dbmail procedure. Look in BOL for a complete list of parameters.

polkadot (10/29/2016)

---

<snip>...A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...

First make sure the SQL Server service is running... Also check the service name to see if you installed a default instance or a named instance.

Additionally (for ease of use)...