Sounds like DNS issues as well

Try a nslookup IP_ADDRESS in command prompt to see if it resolves to a name?

greg

If you are on SQL 2005, look into PowerShell as well, it is great for this purpose. Google for some examples to grab server versions

If not, above batch script is...

For SQL 2005, you should use Database Mail instead of the legacy SQL Mail

Look into Books Online for "Database Mail"

Another reason to always post the error message

Solved by SQL error message

Msg 5184, Level 16, State 2, Line 1

Cannot use file 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data.MDF' for clustered server. Only formatted files on which...

It's too hard to say

so ALL jobs did not run at all at their scheduled times? no Job History or Job Errors?

I would just keep an eye on it for...

I use

BEGIN

...

END

whenever I can, except 1 line IF statement block that can omit BEGIN...END

Easier for collapse/expand in SSMS too

Your thread subject is kinda wrong

You do NOT need the GO statements, everything should run fine

except probably the CREATE CLUSTERED INDEX part (you need a GO after I believe)

Are you...

Just do Import/Export when you're in SSMS

You can save them as .dtsx as...

I totally agree, you should connect via the VIRTUAL NAME or VIRTUAL IP

which goes to the ACTIVE node

and telnet, really? what is that for?

not Remote Desktop?

Assuming you have no compatiblity issue (you shouldn't)

RESTORE DATABASE [db]

FROM DISK = '.............'

WITH MOVE

'logicalDataName' TO 'D:\....',

'logicalLogName' TO 'L:\....'

,REPLACE -- if you want to replace current DB

,STATS -- show progress

I believe it is license PER PHYSICAL CPU, not core

http://www.developer.com/db/article.php/3502746

Of course, the pricing is being changed for 2005 - which is a polite way of saying that it's going up....

What SQL version are you running?

2005/2008

go to either "Services" in Computer Management (or type "services.msc") and look for Reporting Service

or better way is to go to Start -> Programs ->...

I didn't even know you can use parameters for file output names like your @timestamp

If that's the case, is it possible to use either SQL or VB functions to format...

You can always add the IF condition at the top

I like to explicitly drop any temp tables at end of the code as well

IF OBJECT_ID('tempdb..#table') IS NOT NULL

DROP...

In general, 'sa' here as well (to prevent user being discontinued in future and causing issues)

except the ones that get created by the application logins, then I leave them as...