473,321 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Log Shipping inital Backup left in (restoring...) mode

I am attempting to initiate Log shipping from a SQL Server 2005 instance to a separate box running SQL Server 2008 R2 SP1, allowing the 2005 instance to create all the Log shipping scripting. The process completes successfully, but the secondary server database is left in (restoring...). May I have some help in resolving this?

Thank you.
Jun 13 '11 #1
0 1138

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: JB | last post by:
We have a SQL Server 7.0 database running with trunc. log on chkpt and select into/bulkcopy checked and need to develop a backup strategy. One of our DBAs insists that since the transaction log...
6
by: tgru | last post by:
Hello, Can anyone tell me how to backup read-only databases? I want to backup the secondary databases in my log shipping pairs. Thanks, TGru *** Sent via Developersdex...
5
by: shenanwei | last post by:
I have a primary server and backup server located in different physical sites. The primary server is live and ship logs to backup site every 5 minutes. The primary server is being full online...
5
by: Troels Arvin | last post by:
Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The complications related to restoring data are a problem....
2
by: scott s | last post by:
Hello all, I was just awarded the job of maintaing the database server for our company. I have basically ZERO experience using MS SQL Server 2000. Can anyone point me in the direction of a good...
5
by: velu5 | last post by:
Hello , Is it possible/recommended to do SQL server instance backups in Single user mode ? Thanks in advance, atv
0
by: DMT012 | last post by:
Hello. Occasionally on my production server when I run an automated script to restore a database from a backup it hangs and the database is put in restoring mode and just stays there, requiring me...
1
debasisdas
by: debasisdas | last post by:
This is a sample code for taking backup and restore of access database Dim DBTempSource As Database Dim DBTempDestination As Database Dim RecTempSource As Recordset Dim RecTempDestination...
0
by: =?Utf-8?B?TmFzc2VyIEJ1bmR1a2E=?= | last post by:
Hello, Configuring incremental NT Backup in windows XP Professional From start menu go to RUN. ntbackup.exe Advance Mode Backup Wizard (Advanced Mode) Next and specify backup Items Locate...
2
by: heyzulu59 | last post by:
I thought that an online backup could always be run while other processes with the database went about their business. However today I noticed that certain processes in my production database were...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.