In primul rand vreau sa va multumesc pentru ajutor de pana acum. 

Am incercat sa fac ceva teste ca sa imi fac o idee cam cat timp imi va lua toata treaba si sa vad care metoda e mai rapida, dar am intampinat primele probleme. Conform documentatiei, indiferent ca mut bazele de date cu detach/attach sau backup/restore, bazele de date system trebuie mutate manual. Cum pot sa le mut manual? Imi puteti da exemple de query pt ambele cazuri?

Pana acum am incercat urmatoarele query-uri:

• pt backup si integrity verification:

BACKUP DATABASE [bdc_test] TO  DISK = N'D:\incomming\bdc_test_db_200611190556.BAK' WITH NOFORMAT, INIT,  NAME = N'bdc_test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'bdc_test' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'bdc_test' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''bdc_test'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N'D:\incomming\bdc_test_db_200611190556.BAK' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
GO

•  pt restore:
  

RESTORE DATABASE [bdc_test] FROM  DISK = N'E:\incomming\bdc_test_db_200611190556.BAK' WITH  FILE = 1,  MOVE N'bdc_test' TO N'd:\SQLData\bdc_test.mdf',  MOVE N'bdc_test_log' TO N'd:\SQLData\bdc_test_log.LDF',  NOUNLOAD,  REPLACE,  STATS = 10
GO