You need to 'anchor' the query to the entity as well:

SELECT

ROW_NUMBER() OVER (ORDER BY e.value('(./@Id)','int')) AS EntityNumber,

e.value('(./@Id)','int') AS EntityId,

e.query('(./GROUP/RISKGROUP/RISKKEYITEM[@Name="donotshow_EntityGroupRepeatIndex"])') AS EntityRKI,

t.RiskXML

FROM

@table t

CROSS APPLY t.RiskXML.nodes('//ENTITIES/ENTITY') Entities(e)

That returns what I...

Interesting.

If you run:

select * from msdb.dbo.backupset where database_name='<insert you database name here>'

on the original box are you getting anything returned?

That table stores the backup 'run' information. So you should...

Hi,

This is the problem. SQL Server records the backup information in the...

Unforunately there's no way to query a remote...

If it's the number of servers you need to run this on that's the problem, then you have a couple of non pure SQL options as well (assuming they aren't...

Yes, that's all doable. The only thing the existing contractor could do is refuse to allow it to be connected to 'their' network, though that'd be getting very petty.

I'm assuming...

johnitech.itech (2/2/2012)

---

:w00t:

we are experiencing the following error when backing up :

A nonrecoverable I/O error occurred on file "" BACKUP DATABASE is terminating abnormally.

Reading some posts on this forum I...

rakeshraj.sinha (2/2/2012)

---

Thanks's for your reply..

I have implemented the SFTP using WinSCP. but, this third party tool does not return any success or failure flag,

How can I sure that file...

Nope, it isn't possible without a 3rd party tool. As far as I know no current version of Windows ships with a built in SFTP client, though I'm happy to...

Which SFTP client are you using?

Do you have any disk space monitoring? Has another backup file grown large enough to fill up the space, but is then being deleted by a cleanup script running between...

Just evict the old 'node' record, and then add the reinstalled node.

Don't try replacing the old node as that will only cause confusion later on.

Is the procedure creating the empty folders for the backups? If not, it could be permissions

Have you tried running the script without the xp_delete_file line?

Just to Clarify:

You have Windows Node A, which hosts SQL instances 1 and 2

You have Windows Node B, which hosts SQL instances 3 and 4

You have Windows Node C, which...

That's a 'normal' warning.

It'll let you install SQL Server OK. But before you run SQL Server, download and install Service Pack 1 for SQL Server like it says.

You can 'install'...