Hello,
I want to setup SQL Log Shipping btwn two servers.
- Do the servers have to run same version of Windows? Can one be Win2003 and
the other Win2K Server? Or one Win2k Advanced and one Win2k Standard Server?
- Do I have to run the same version/build/ServicePack of SQL Server?
many thanks
christos
If you are using the Enterprise Edition of SQL Server's Log Shipping
functions both SQL Server's have to be Enterprise Edition. If you are
rolling your own version of Log Shipping, there are no SQL Server version
requirements or OS requirements (other than NT workstation/server, XP
professional, Win2k server/professional, Windows 2003).
"Christos Kritikos" <ChristosKritikos@.discussions.microsoft.com> wrote in
message news:D025AB19-599D-4806-9817-2804C182F38A@.microsoft.com...
> Hello,
> I want to setup SQL Log Shipping btwn two servers.
> - Do the servers have to run same version of Windows? Can one be Win2003
and
> the other Win2K Server? Or one Win2k Advanced and one Win2k Standard
Server?
> - Do I have to run the same version/build/ServicePack of SQL Server?
> many thanks
> christos
>
Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Friday, March 23, 2012
Log Shipping problem
Dear Friends
I have a SQL Standard version and due to same i am not
able to do the log shipping for the database i want to
create a backup server which is only for analysis and the
same need to update only once. I can not set the
replication between the server as the Database is not
compatible for the same it is having 1024 column in many
tables.
Now What i have done is created a maintaince plan for the
backup and transactional backup in a 24 hours.
The same are replicated to the other server hard drive
with Data Replication service.
I want to create a job which will automatically restore
the transaction log on the analysis server.
Please suggest how can i achive the same. Your earlier
reply would help me a lot.
Best regards
Sharad
Take a look at the walkthrough and make sure you have only ONE database
selected at a time in the DB Maint Planner and it's in Full Recovery mode
when you have decided which one to select.
http://www.microsoft.com/technet/pro.../logship1.mspx
Hope this helps
Paul.
I have a SQL Standard version and due to same i am not
able to do the log shipping for the database i want to
create a backup server which is only for analysis and the
same need to update only once. I can not set the
replication between the server as the Database is not
compatible for the same it is having 1024 column in many
tables.
Now What i have done is created a maintaince plan for the
backup and transactional backup in a 24 hours.
The same are replicated to the other server hard drive
with Data Replication service.
I want to create a job which will automatically restore
the transaction log on the analysis server.
Please suggest how can i achive the same. Your earlier
reply would help me a lot.
Best regards
Sharad
Take a look at the walkthrough and make sure you have only ONE database
selected at a time in the DB Maint Planner and it's in Full Recovery mode
when you have decided which one to select.
http://www.microsoft.com/technet/pro.../logship1.mspx
Hope this helps
Paul.
Subscribe to:
Posts (Atom)