Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yjpr
Starting Member
1 Post |
 Posted - 2006-02-22 : 18:44:39
|
| I am currently refreshing the Reporting Server Database from Production database(size 200mb) every night by using backup and restore as follows:Restore Database ProjectDB from disk = 'D:\MSSQL\BACKUP\RptBak\ProjectDB.bak' with move 'ProjectDB_log' to 'd:\Mssql\Data\ProjectDB.ldf', move 'ProjectDB_data' to 'd:\Mssql\Data\ProjectDB.mdf'I usually take Transaction Log Backup from Production every hour everyday. I am planning to apply the transaction log every hour on Distination Server Database (7am to 9pm). Is it right way of doing it? I am confused whether to use WITH RECOVERY OR WITH NORECOVER while restoring a database.I am getting errors(Msg 4306) when applying the log.Can anyone help me how to apply incremental transaction log to the restored database(step by step)?Appreciat your help.-YJPR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 18:47:02
|
| In order to apply tlogs, you must be in NORECOVERY mode or STANDBY mode. If you use STANDBY mode, the second database will at least be available in read-only mode. With NORECOVERY mode, no one can connect to it.I'd recommend using transactional or snapshot replication for your reporting database instead of backups.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Refresh the MS SQL Server 2000 Server database eve