You may check which process is using that file using Process Explorer. Also you can add a WAIT/SLEEP value so that there is delay between robocopy and copy file process.

You have to use a custom query and (or) save it in a file. You may use the -I switch or -Q switch to call that query as an input...

Yes you are right. The ":" in your backup file is causing this issue. Without the : the backup should be fine. The ":" symbol is used only at...

I don't know what do you mean by the page size of disk. In SQL Server the page size is 8 KB.

Books Online is the best resource to get these details. However, you may refer these links.

ROLLBACK TRANSACTION

KILL

DBCC OPENTRAN

DBCC INPUTBUFFER

Can you please try changing the start date of the job to today, for the ones which have very old start date?

You may try the "workaround" mentioned in this article. Even though it is for SQL 2000, it is worth trying.

Also could you try changing the start date of the job...

Please add an output file to the job (under Job Properties --> Job Step --> Advanced). This will give you the entire job run history

Check if this discussion helps.

Modify this line as below.

RS.Open "Exec getStaffAppointment " & myStaffId & "," & myStartDateUS & "," & myEndDateUS,objConn

Since the requirement is to retain some of the data in the original database, the best option is to restore the backup provided by the vendor on to a new...

Yes. It should be smooth sail. Please ensure to have good backups for the instance. During the migration all you have to do it Stop and Start the SQL Services.

You may find this post useful.

First of all it is not good that there is no static IP. Atleast there would be a static server name? You may use the server name in the Import/Export...

Did you try the code which I had posted earlier? If that did not work can you please check the value of Resume key in

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

MSSQL.1 needs to...