Hi Dmitriy,

please check:

- do you have write permissions on C:- do you have admin permissions on both Servers

- try to use the servername,port for the target machine e.g. CopyDB.cmd server1...

Hi Christian,

in our environment it still runs also with cluster instances. Just use the cluster virtual name in your parameters. The network path with the virtual name should be abailable.

For...

Hi Robert,

thanks for your post. The only external (non DOS) command that is used in the script is SQLCMD.exe provided by SQL-Server 2005 Client Tools and higher. So it is...

Very nice script, thanks for it. I have a suggestion for it so it will work also in a mirroring environment if not all databases are principle or if a...

Hi,

I've found the mistake... I have to use the "with replace" switch wilth the restore statement.

Complete:

RESTORE DATABASE Master FROM disk=N'F:\MSSQL2005\Backup\masterDumpDat.bak' with replace

Roland