Transferring SQL 2008 DB
I have an SQL 2008 DB and I need to transfer the structure and the data to an o开发者_运维知识库ff site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008. What are my options?
Straight backup and restore should do the trick with [Force restore over existing database] option set on restore.
精彩评论