Stewart "Arturius" Campbell (3/5/2014)

---

Alternatively, change the recovery model to bulk logged just before the load and back on completion thereof.

however, this will require a full backup before and after.

Bulk logged...

Interesting question! thanks Craig.

Good one! thanks.

Take the backup of the server locally and transfer it to the laptop. If you would like to automate you can do so by creating job.

Easy one, thanks.

Thanks you everyone!

The objective to post DSQ question is to let people explore more about DSQ :-).

Check the following link which might help you:

http://www.sqlservercentral.com/Forums/Topic782209-24-1.aspx

http://www.sqlservercentral.com/Forums/Topic1041837-357-1.aspx

http://community.spiceworks.com/topic/282881-automated-restore-of-sql-2008-database

HTH

Easy one, thanks Mike.

Easy one, Thanks Ron.

Are you able to connect to the server and database? What access you do have on server and database?

Also you can do Detach/Attach of the databases which will be easier and faster.

I don't think you will be able to rename named instance.

Easy one, thanks.

Good one!

Stewart "Arturius" Campbell (2/21/2014)

---

I can understand why one backup of a read-only db might be needed, but would subsequent backups be necessary or relevant, as nothing would have changed?..

Interesting question,...