Sql backup and restores

[shelley]

I have a database 30 GB in size. I need to copy this entire database to
laptop. I want to use backup and restore database on this laptop.
I need to know how I can accomplish this wihtout copying the backup file
to the destination server. Is there a way you can restore from a file over the
network from a different server?
I tried everything,with the security setup but was not able to do this.
Any recomendations will be valuable.

[Peter Karhatsu]

I beleive the best way fo you do this is with sp_detach and sp_attach. This will require enough downtime on your production server to copy over the 30gb file(probably around 2-3 hours depending on bandwidth.
I've never done a full restore over the lan, it should work though... map a drive on your laptop to the SQL drive where the full disk dump is located and restore the db poiting to the device(mapped drive), that should work...
Good luck, hope this helps.

------------
shelley at 10/5/00 10:10:09 AM

I have a database 30 GB in size. I need to copy this entire database to
laptop. I want to use backup and restore database on this laptop.
I need to know how I can accomplish this wihtout copying the backup file
to the destination server. Is there a way you can restore from a file over the
network from a different server?
I tried everything,with the security setup but was not able to do this.
Any recomendations will be valuable.

[Gurukiran]

You can certainly backup / restore over the network. If you are backing up locally and restoring on your laptop, make sure :

1. The user account you use to log in to your laptop and the domain has r/w access to the Server you are restoring from.

2. The SQL Server service and the SQL Server agent on your laptop are running with domain accounts with the same level of r/w access to the network drive on the Server.

You can choose right click on the database on yr laptop, choose 'restore', and choose 'from device' and use UNC to name the backup file. 30 GB is kinda high, though, isn't it, for a laptop ?

------------
shelley at 10/5/00 10:10:09 AM

I have a database 30 GB in size. I need to copy this entire database to
laptop. I want to use backup and restore database on this laptop.
I need to know how I can accomplish this wihtout copying the backup file
to the destination server. Is there a way you can restore from a file over the
network from a different server?
I tried everything,with the security setup but was not able to do this.
Any recomendations will be valuable.