Can you post whatever errors you are getting and what you are doing when the errors are generated? Errors in the SQL Server log, errors in whatever process - backup?...

Lynn Pettis (9/22/2016)

---

Luis Cazares (9/22/2016)

---

drew.allen (9/22/2016)

---

Sue_H (9/22/2016)

---

My thoughts as well. The follow up to that specific question could be interesting if someone doesn't know what would be...

I'd check the SSRS log for whatever server is experiencing the slow down and see what SSRS is doing at the time since it could be something like recycling. Other...

My thoughts as well. The follow up to that specific question could be interesting if someone doesn't know what would be different between the two.

Yup. Lots of shops where it's the only allowable solution as well, requiring scripts to be...

Yes the login was successful as the backup began and then "BACKUP DATABASE is terminating abnormally". So the login and the start of the backup. I could be a UAC...

The row_count in sys.partitions would have the record counts. As already indicated, you could just generate the drop statements using a query with sys.partitions -

SELECT 'DROP TABLE ' +...

Is this a DQS project? If so it's listed that only string values are imported. This article lists values that will be imported and values that won't be imported:

https://msdn.microsoft.com/en-us/library/hh479581.aspx

Sue

You have other backups going on other than native backups. Add device_type from backupmediafamily in the query you had used earlier - you'll be able to tell by looking but...

anthony.apollis (9/21/2016)

---

Can somebody assist me please?

I tried to correct this error with no luck!(please see https://connect.microsoft.com/SQLServer/feedback/details/622737/user-does-not-have-required-permissions-verify-that-sufficient-permissions-have-been-granted-and-windows-user-account-control-uac-restrictions-have-been-addressed)

Please explain to me what "Folder Setting" are they talking about and where do i...

SQL-DBA-01 (9/21/2016)

---

Hello,

Granting the permission to run trace is simple, but if I need to check who all users have executing profiler trace, how to do that by running a simple...

Shrinking files is not a good thing and is rarely needed if you're managing your log files. Things can come up as a one time, blew up a log and...

Phil Parkin (9/20/2016)

---

Sue_H (9/20/2016)

---

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with DBMail...

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with DBMail as it executes...

tcronin 95651 (9/20/2016)

---

thanks the upgrade path has been clear there are a few unclear articles I have seen which seem to question whether or not you can do an in...