"Copying" a database RRS feed

  • Question

  • Hi.

    I have an MS SQL db created in SQL Server 2008 Web Edition on my laptop.

    It contains (in addition to standard tables), a small number of Stored Procedures, ASP.NET Membership tables (such as dbo.aspnet_Membership) and login/permission information. There is also one FullText Search Catalog and 7 of the standard tables have indexes.

    What is the best way to simply copy that database (complete) to a remote server. The remote server is Windows 2008 and the remote database is SQL Server 2008 Web.

    I have SQL Server Management Studio installed on my laptop AND server.

    p.s. I have tried the Copy Database feature but this stalls telling my Sql Server Agent is not running, when it is.

    • Edited by banksidepoet Wednesday, February 15, 2012 5:18 PM
    Wednesday, February 15, 2012 5:05 PM


All replies