Backup & Replicat Databases

[RPG42]

Hi,

I figured out how to copy databases, but for some reason the primary key definitions aren't being transferred.

Anyone know how to do that easily?

I need to make annual archives.

PlantData exports to

PlantData2001
PlantData2002
PlantData2003

Etc.

Thanks,

RPG

 

[btturner]

BACKUP DATABASE PlantData TO DISK='e:\PlantData.bak'
--then
RESTORE DATABASE PlantData2001 FROM DISK='e:\PlantData.bak'
WITH RECOVERY

--or Try using the DTS 'COPY SQL OBJECTS TASK'

 

[mrdenny]

When restoring the database you'll need to use the WITH MOVE options to change the file names on the disk, so that you aren't trying to overwrite the production database.

backup database PlantData to disk='E:\PlantData.bak'
go
restore database PlantData2004 from disk='E;\PlantData.bak'
WITH MOVE 'PlantData_data' to 'd:\MSSQL\MSSQL\Data\PlantData2004_Data.mdf',
MOVE 'PlanData_Log' to 'd:\MSSQL\MSSQL\Data\PlantData2004_Log.ldf'

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)