@hiramfleitas: Error is the correct description because if "Msg " appears in the output it's an error 😉
@

Hi Manu, I saw your short script in the newsletter today and it inspired me. Thanks! Yes powershell is nice but you always need the correct environment, powershell version, permissions,...

Thank you mick.regan for answering. I will try to complement your answer a little bit:

The script gets the default log (and data) path with the following statement:

SELECT CAST(SERVERPROPERTY('instancedefaultlogpath') AS NVARCHAR(512))

the...

Hello Metcalfe,

sure it is not possible to downgrade databases. To do so you have to create a new database on the old version SQL-Server and transfer the objects of the...

Hi psheperia,

no, there are no plans because I don't use Azure.

Best regards, Roland

Hello all,

as promised I've now tested the new version (20141104) and you will find the download here:

http://rolx.de/download/CopyDB.cmd

This version now supports blanks in path and filenames. Nevertheless I recommend not to...

Hi mprokop04,

do you mean something like this:

1.) Open a query on the source server

2.) Run: select 'call c:\temp\copydb ' + @@servername + ' TargetServer\TargetInstance ' + Name + ' offline'...

Hi Mick,

thanks for your modifications. I did some more modifications and after they are tested I will provide the command file here again.

Regards Roland

Hi ofirgeller22,

your syntax is correct in this way. Are there blanks in your paths or filenames or database names?

Maybe it will help if you run the statement on the source...

Hi joe.tj,

sorry, I don't have experience with Chinese OS. Maybe this will help:

Try to save the file directly to your HD. Do not open it in an editor.

or

Replace the frame...

Hello,

@Christian: Thnks for the hints. I've fixed the bugs. (http://rolx.de/download/CopyDB.cmd)

@JunkIt: No! As I know it is not possible to copy a database from a newer to...

O.K. sorry, some more details:

- the user has to be a domain key

- the user has to be granted to access the \\Server\x$ shares

- the user needs write permissions on...

Look at the bottom of the article:

http://www.sqlservercentral.com/articles/Copy+Database+Script/107377/

direct link:

http://www.sqlservercentral.com/Files/CopyDB.cmd/23588.cmd

Regards, Roland

Thank you for your tips. I use the script since many years and it always worked fine for me. O.K. I dont use blanks in my path and filenames (old...

Hi Christian,

please try this...

http://rolx.de/download/CopyDB.cmd

Regards,

Roland