recovery from different server.

Question

recovery from different server.

SQLRep

SSCrazy

Points: 2052
More actions
January 20, 2005 at 9:14 am

#152335

hi all,
have one question that how can i restore database on my local test server from server in uk. it is hard to copy that back up file from that server to on my testing server. is it possible that from sqlem i can user restore function to use that backup file to restore my dabase!?

thanks in advance

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

magasvs SSCertifiable Points: 7660 More actions · Answer 1

You can use DTS task - Trasfer Databases to copy database between servers, but you need to have SQL Server 2000 and it will be some extra network traffic during coping process.

SQLRep SSCrazy Points: 2052 More actions · Answer 2

but is there a way that i can user restore procedure to restore database from back up file on different database server. is there a command that i can user back up file on different server to restore database on local computer or server?

Thanks

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

Don't use the copy database wizard because it detaches the source-db for a while (and reattatches it).

You may want to consider using restore using UNC.

Restore database MyDb

from DISK = '\\myserver\disk$\msSQL\BACKUP\mybackup.BAK'

with MOVE N'mydb_data' TO N'newdatapath\mydb_data.mdf'

, MOVE N'mydb_log' TO N'newlogpath\mydb_log.ldf'

, RECOVERY

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

SQLRep SSCrazy Points: 2052 More actions · Answer 4

hi there i tried that but it could not open the back up device but it is shared on network! what could it be wrong?

thanks.

Jason Hall Hall of Fame Points: 3906 More actions · Answer 5

Even though its on a shared network make sure that you have permissions to the network drive and folder that the backup file sits in.

You can try an xp_cmdshell 'dir <>' and see if you have permissions to the drive.

SQLRep SSCrazy Points: 2052 More actions · Answer 6

hi i have set the permission for everyone for full access. but still getting error!

Thanks

SQLBill SSC Guru Points: 51440 More actions · Answer 7

Full access meaning what? If you mean full access on the computer, that's not good enough. If you don't have the proper access on SQL Server, you probably won't be able to do the backup/restore.

-SQLBill

Deni Kusdeni Default port Points: 1457 More actions · Answer 8

The point is, the user startup for the SQL Agent must have permission to the network share, where the file exists.

Regard's

-DENI-