So, if my largest data in around 40gb then would I need only need 80gb extra free space?

Sorry to be a pain!

Thank you for your reply!

I have run the SQL server "Index physical stats" report which gives all the indexes which would need to be removed and also the "Disk usage...

thank you for your reply!

I have the following script, but it only does a restore of the transaction log; the script doesn't have the flexibility to pick the latest file:...

Thank you for your reply!

I get return values when I execute the script and I get a return value without any access issues.

The package gets data from various servers but the job which I'm trying to create is on a different server.

As I said I'm not sure if that is...

Thank you for your reply. I have already tried to recreate the proxy. The only thing which is unusual is that the source data is on another server but the...

Thanks for your reply!

The parameters are all running fine. I'm only having the issue when setting up the job in SQL but executing the packages in visual studio all seem...

Yes, I'm setting the source database to get the information and also a parameter for the destination sever.

Thank you!

I'm sorry if I'm not being clear but I can only see what I've already sent you, basically, when I run the following:

-- 9 - Populate the #ParsedFileList table with...

CONVERT(date, col1) AS 'DateTimeStamp', is the line I've chabged unless I need to change it to something else?

and I get the following error:

Conversion failed when converting date and/or time from...

I have now changed the date time to be converted to date but I still get the following message:

Conversion failed when converting date and/or time from character string.

-- 9 -...

Thank you for your reply!

I commented out the insert into statement but all I get in return is the details about the files, e.g. file name file extension. LSN etc...

Dear All,

I apologise for the previous post!

I'm trying to create an email report which gives a result of multiple results from multiple databases in a table format bt I'm trying...

I had the same issue where I was trying to restore from a Redgate backup so in the end I used the native backup and restore - it just took...

I tried using the following script to set up the SMS for the provider tmobile for example, but it still does not work,

USE [msdb]

GO

EXEC msdb.dbo.sp_send_dbmail

@recipients...