jlavery
asked on
move sql 2005 database to another sql 2005 database - no management studio or sa password
Hi,
got a dog with fleas..
client has a sql 2005 sp2 database on a unstable win2k3 sp2 server. they wish to move that sql database to another sql 2005 sp2 server, however they do not access to Management Studio on the source server nor do they have the sa password for either environment.
mdf an ldf files are available to be physically moved.
need a safe, clear cut method of moving this data without getting jammed up as well as a method to perform automated backups via management studio on the target sql server.
thank you.
got a dog with fleas..
client has a sql 2005 sp2 database on a unstable win2k3 sp2 server. they wish to move that sql database to another sql 2005 sp2 server, however they do not access to Management Studio on the source server nor do they have the sa password for either environment.
mdf an ldf files are available to be physically moved.
need a safe, clear cut method of moving this data without getting jammed up as well as a method to perform automated backups via management studio on the target sql server.
thank you.
If the security is working properly you should not be able to do anything without the "sa" password.
Normally you would use SSMS (free download from MS) to back u the database on the old server and then restore it on the new server.
Note: You can install SSMS on any workstation on the network. You can manage any SQL Server instance on the network if you have the proper credentials to log on.
Normally you would use SSMS (free download from MS) to back u the database on the old server and then restore it on the new server.
Note: You can install SSMS on any workstation on the network. You can manage any SQL Server instance on the network if you have the proper credentials to log on.
... as well as a method to perform automated backups via management studio on the target sql serverIt is my understanding per the EE rules that the additional question about automated backups should be in a separate question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
client decided not to move forward with the activity. shared the points with what was determined to be the best answers available and rewarded their efforts
Now to actually move your files you need to copy .mdf .ndf and .ldf files
you should move them to the same path on the new machine to avoid any complications.
Note: I haven't really done this before, but I believe it will work.