Activity overview
Latest activity by Rajnish Awasthi
Red Gate Jobs Getting Failed (Urgent)
Hi
Yesterday i changed the sa password for all instance where red gate was also running to generate full backup and logshipping logs, my all jobs and maintenance plan is running perfectly which wer...
Low Physical Memory Alert
Hi,
I have one database server which have two processors and 2 GB physical memory,i am confuse here that it showing me low physical memory alert and showing that free memory is 178 MB.
Is really sq...
Thanks for reply,
but I found a pdf file where it is mention that sql backup pro should be installed on both server.
May be it is required because this red gate tool use compress version of backup file which should be uncompressed on secondary server. Prerequisites
To perform log shipping using the SQL Backup Log Shipping wizard:
•
You must have at least two SQL Server database engine servers or two database engine instances in your log shipping implementation.
Note that you cannot ship transaction logs from a SQL Server 2005 database to a SQL Server 2000 database, because of the differences in their structures (but you can ship from a SQL Server 2000 database to a SQL Server 2005 database if you use No Recovery Mode – see Choosing the Log Shipping Mode later in this article).
•
SQL Backup Pro must be installed on both of the SQL Servers.
•
The database must use the full or bulk-logged recovery model.
•
You must have a shared folder to copy the transaction log backups to.
The SQL Server Agent service account of the primary server must have read/write access either to the shared folder or to the local NTFS folder. The SQL Server Agent account of the standby server must have read and delete access to the shared folder.
•
The SQL Server Agent services must be running and configured with network credentials (such as a domain account) if you plan to use a network share as the shared folder.
You can configure log shipping with SQL Server Agent services stopped, but the process does not run until the agent is started. / comments
Thanks for reply,
but I found a pdf file where it is mention that sql backup pro should be installed on both server.
May be it is required because this red gate tool use compress version of backup ...
Red Gate Should Install On Both Server Primary and Secondary
Hi,
I am just confuse that should i install red gate software on both server primary and secondary to apply log shipping ?
Rajnish
Yes , That was something urgent that's why i paste my query in forums also.
Thanks to reply, Its now resolved. / comments
Yes , That was something urgent that's why i paste my query in forums also.
Thanks to reply, Its now resolved.
Log Shipping Issue
Hi all,
I am facing one issue in log shipping while restoring job is running on secondary server. Log shipping was working fine in first 45 minutes but after that it giving following error .
VDI er...
Log Shipping Issue
Hi All,
I am facing a issue in log shipping. In begining, its working fine but after 30 minutes it gives an error while restoring log file on secondary server.
Following error is coming on screen:-...