robocopy will do what you need, thats how we manage shipping BAKfiles from prod to DR, but use logshipping for TRN's to provide the DR so we dont need to...

alwaysgirl59 reported as spam posting

yes there will be downtime as the resources need to move from node1 to node2. the amount of time depends on the environment, in clusters I've worked with before...

you can assign at either host or guest level.

as you are using standard licences you can only host this at guest level

enterprise is 4 virtual machines at host level

data centre...

yeah it is the headbang gif, felt it was appropriate given some of the forum topics at the moment.

I will check the gif out on Monday for its size and...

Saggy (2/17/2012)

---

Date2/17/2012 8:59:07 PM

LogDatabase Mail (Database Mail Log)

Log ID7

Process ID6836

Mail Item ID3

Last Modified2/17/2012 8:59:07 PM

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server...

thanks, its an animated gif, but some reason the animation is not happening.

what have you tried, whats not working and what errors are you getting?

take a look at "sp_change_users_login" and "alter user"

The error says authentication, so take a look there first.

bad username and password?

SMTP server allows the SQL server to send SMTP mail?

using no authentication when SMTP needs authentication?

ask your SMTP...

Firewall blocking SMTP port?

SMTP server not allowing your IP to send mail?

AntiVirus blocking mass mail?

Authentication?

The error says authentication so check you mail server authentication and ensure that user has access...

I would use version control software like TFS giving each change of the package a version number allowing you to get a specific version out of source control

if you can do side by side then this is by far the best approch to upgrading.

you could do side by side now, but would mean you need to create...

Messy but works

DECLARE @Date DATETIME

DECLARE @Tab TABLE (Y VARCHAR(4), M VARCHAR(2), D VARCHAR(2), T VARCHAR(11))

SELECT @Date = DATEADD(HOUR, DATEDIFF(HOUR, 0, GETDATE() ), 0)

INSERT INTO

@Tab

SELECT

DATEPART(YEAR,@DATE),

DATEPART(MONTH,@DATE),

DATEPART(DAY,@DATE),

CASE DATEPART(HOUR,@DATE)

WHEN 00 THEN '00:00:00 AM'

WHEN...

just wondering, do you know where iteration capacity and individual capacity is stored in the warehouse so we can see if a iteration or person is over or under estimate...