Viewing 8 posts - 1 through 8 (of 8 total)
Hi,
No I was unable to restore the master db succesfully. So I`ve had to restore indidivual User db's manually, then sync\recreate logins,tasks,dts,catalogs and backup devices all manually.
I too can`t...
October 12, 2006 at 2:21 am
Hi,
Unfortuneately their will be no F:\ drive on the new server. The only drives available on the Second server(destinaton)are:
C:\ [system] program files(x86\microsoft sql server\mssql\binn
D:\[data]MSSQL\data
E:\[Logs]MSSQL\Data_Logs
the primary server includes C:\, D:\, E:\...
October 10, 2006 at 7:09 am
Yes, thats correct and I select force restore
October 10, 2006 at 5:51 am
Hi, I dont think that order to oder of restoration is correct as the primary server data files are located on the C:\ drive and the Destination Data file are...
October 10, 2006 at 5:17 am
Hi, I restored master to secondary, while in single user mode. Restarted the Sql services and then lost connectivity to the server, as the sqlservices immediately shutdown. Sql error log...
October 10, 2006 at 4:39 am
Hi dharpr3,
You are correct I did not restore the msdb and model databses from primary to secondary server, I assumed that i would be able to complete this after restoring...
October 10, 2006 at 2:36 am
Here's a copy of SQL error log after restoring the master DB>>
The missing User database errors are expected as I haven`t copied across these yet until I`m able to restore the master...
October 9, 2006 at 8:39 am
Thx for the Links,
Unfortunately, the disc structure between Primary and secondary Servicers the Disc stucture and partions aren`t the same.
Also can`t copy source master data files to destination as primary server is...
October 9, 2006 at 8:08 am
Viewing 8 posts - 1 through 8 (of 8 total)