SQL Server Performance Forum – Threads Archive

log shipping or replication

I have a reporting server that I have been restoring each night from a backup of production but I’d like to switch this to either use log shipping or replication. The reporting server can be in read-only mode. Does anyone have any suggestions, warnings or advice about which would be a better way to go? Any help would be appreciated.

Log shipping is a better solution since it seems you need the entire database on your reporting server not some selective objects. You need to have the primary server set to Full recovery mode and you need to stop all Log backups if you have any scheduled! Also you can set the reporting server as Standby mode to keep it in read-only mode.
Refer to thishttp://www.sql-server-performance.com/sql_server_log_shipping.asp link for complete information and also take help of SQL books online.

Use windows logins only. SQl Server logins will be orphaned when the reporting db is initially restored on the secondary server.

I have lots of SQL Server logins on that database and only a few Windows logins. If a create scripts to redo the logins can I restore the source database on the destination server, run the scripts recreating the logins, and then move forward from there letting the system ship over the logs and restore them?

Can take help of thishttp://www.databasejournal.com/features/mssql/article.php/2228611 link for migrating logins from one server to another. Refer to this site’s linkhttp://www.sql-server-performance.com/q&a37.asp about handling logins while restoring the logs on secondary server on top of the Walidha’s reference on log shipping setup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>