is it possible to take the system databases backup to a location of another server.

(i.e ) shall we able to take a backup of the databases from server 1 and putting in server2

I know we can move the databases backup file , but above condition is not possible , but before working on this stuff i wamt to make sure.

I think it can be done on a network share. Though so far we follow having the backup taken on the same server and then move it to other server later using vbscript as backups are huge in size. These were done for production dbs, and not for system databases.

Let me try that and confirm

Cheers

_________________________
- Vijay G
Strive for Perfection

The only way I have see this done is install the same version of the database on the other server with same service pack versions. Then shutdown the source database, copy the data not from SQL but from a file copy, then try to start the service. But you have to be installed on the same drive letter, same path, etc. for this to work.

But to have it work that way, you should change the server1 reference from the system databases to the server2. I am not sure if the original poster is referring to that. I hope it was posted to know if a backup can be taken from one server to the other. Hope I am not wrong.

cheers

_________________________
- Vijay G
Strive for Perfection