had problems trying to move an audit database from sql2005 to sql2008. When i go to restore it wants me to use the ev directory mdf files and I haven't found a way around it. I don't want to use the option restore with replacement cause I believe that will overwrite the files... Any ideas... EV 8.0sp3 win 32 bit going to 2003 64 bit sql 2008 sp1.
I did do a full backup of audit to a .bak file, when i go to restore in sql the mdf file it needs is the same one as the directory db so it wont let me use it unless i do a with replace option in sql. Its using the vaultdev70 and vauldev1log70 files the same as the directory db....I already restored the directory db...
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'sql2008'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\EnterpriseVaultAudit.mdf' is claimed by 'VaultLog70'(2) and 'VaultDev70'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476