When copying a database for development or testing purposes, there are a number of parameters that need to be set in the SQL query.

Assuming VCBD is the existing database, and vCenter is the destination database.

Backup query:

BACKUP DATABASE [VCDB] TO DISK = N'D:\Backup\VCDB.bak' WITH COPY_ONLY
GO

Restore query:

RESTORE DATABASE [vCenter] FILE = N'VCDB' FROM  DISK = N'D:\Backup\VCDB.bak' WITH FILE = 1, MOVE N'VCDB' TO N'D:\MSSQL\Data\vCenter.mdf', MOVE N'VCDB_log' TO N'E:\MSSQL\LOG\vCenter.ldf'
GO

BACKUP (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms186865.aspx

RESTORE (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms186858.aspx