Endpoint Protection

I have sql 2005 express installed on one of our servers with SSC installed on the same box. Soon I will be upgrading to SEPM, but with more clients we will need a larger db which we have in a sql 2005 server. What is the recommened way of taking the db from the local sql 2005 express and place it on the sql 2005 server? Is it just a matter of backing up, detatching and attaching the db to sql 2005?

http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008041601053448



.......Barkha

I followed their documents, I detached from the SQL express, copied the files over to our SQL server, attached and then had to make one change to the rights or users, otherwise everything made it. So DO check the rights and users and all when done.
You can backup and restore, but in our case, we don't use the default C drive location for SQL data, we use an E drive, so it was easier to place the files where we wanted and attach.
Their document were so easy, even I was able to do it and SQL scares me a bit.
The SQL Express files were HUGE, so our DBA did some tweaking and it went from multiple GIG down to UNDER a gig.