Copying DB in express | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copying DB in express

Hello! I’m a newbie. If this is not for me, please tell me and I will quietly disappear…
If not, please consider helping me. I need to make an "independent" copy of a database in MS SQL server Express Edition. Independent in the sense that it looks as, behaves as and IS a totally other database (identical in every way except for the name). In the full version this can be done in tasks/copy, but that feature seems to be missing in express. If I have to do this by writing script I would need full guidance from beginning to end. I will probably not know the meaning of half of the words you will be using and so I have to keep asking ’til I get it. Anyone feeling up to it? Any help would be HIGHLY appreciated. Kungen
Welcome to the forum! You are at right place [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />What do you mean by FULL version?<br />If you mean to say in Standard or Enterprise edition then yes there are more differences on the way the SQLExpress and other SQL editions tackle the database performance.<a target="_blank" href=http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx>http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx</a> gives you more information on the features comparison.<br /><br /><br /><br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
]]>