No, i meant whether there are other errors like ntfs errors or Hardware errors in the Log.

An important Thing would also to check the permissions of the service Account. Has...

Have you looked for other errors in the Event Logs?

Hi,

With registered Servers it could be ok. Add two Server to the registered Server, Export it and try to generate the XML with select on the Server list. And Then...

Have you tried to backup the Database on a local Drive? Is there the Same error?

Has the SQL Service Account Full Control of this Share?

On which Type of device you are backing up?

Hi,

have you first checked the backup with restore headeronly?

Occurs the error on every backup?

Hi,

i think the following statement would help.

update t

from Table t

inner join (

select area,

[year],

max(benchmark) benchmark,

...

Hi,

have you kept the firewall settings in mind. Have you allowed the remote powershell ports?

http://blogs.technet.com/b/christwe/archive/2012/06/20/what-port-does-powershell-remoting-use.aspx

Another possibility to check the running server:

You can use the Registered Servers feature of the SSMS....

Hi,

you have three types of backups.

full - which can be restored independent from any other backup

differential - which is based on the recent full backup

log - which is based on...

Hi,

are you sure that there is no session open by the job? Why did the job is canceled without changing the state? Perhaps an entry in the sql error log?

Please...

Hi Anthony,

the question is, what do you want to do?

Do you want to check whether at least one row is returned? Then take:

IF exists(SELECT 1 FROM VERSION

WHERE PATINDEX ('7.0%', VERSION)>...

Hi,

you can use the full name of the tables of the different databases in your view select statement.

select * from [database].[dbo].[tablename]

Hi,

have you looked in the data collector folder on disk? Are there any data files?

Have you checked the MDW reports about the specific data?

Hi Andy,

you should first restore your full backup and after this the log backups until 12 am. The important part is that you should restore the log backup from 2...

Thanks a lot for making me sure. 🙂

Greets

Patrick