Re: error when using log shipping

You can also do a restore database databasename with recovery

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:A0EB2ED2-3872-43D5-8CB6-F74575CEE845@xxxxxxxxxxxxxxxx
Hi Roy,


You can bring the secondary database online by restoring a tail /
transaction log from the primary using "Recovery" from the Restore
Options. Restoring a database using "Recovery" is the last operation to be
processed in a restore operation. It finalizes the restore operation. In
Log Shipping and Database Mirroring, "NoRecovery" or "Standby" options are
used to keep the secondary / mirror databases up to date all the time.

Log Shipping and Replication are called Warm Standby options. Warm Standby
means, system can not failover automatically to the other server in case
of a failure that may occur in the primary server. You have to switch /
failover to the secondary server manually when you use these technologies.
If you are looking for a Hot Standby system and want to use the secondary
server as a report server then you can try to set up a SQL Server
Active\Active two node Failover Clustering.


--
Ekrem Önsoy



"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:eH%23smLY6HHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
Correct:

After running the restore section, Just the restore database the database
becomes in restoring mode and don't use. His files don't growth and even
when i reset the server it still stuck in this mode.

The only way to revive it is by delete the database and do restore with
recovery model.

Whay is that?

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:ekLbGyX6HHA.600@xxxxxxxxxxxxxxxxxxxxxxx
Hello Roy,


In Log Shipping, the secondary server is supposed to be inaccessible.
There are two modes of it. One is Norecovery and the other one is
Standby.

In Norecovery mode, users can not connect to the secondary server
database.

In Standby mode, users can connect and query the secondary database. But
this time, logs can not be merged with the secondary server database
unless all users are disconnected.

You can not use Database Mirroring' s mirror database as a report server
because it is also going to be inaccessible. The only way you can use
the mirror server as a report server is to use a database snapshot
and update it periodically (you may use jobs for this)

If you want to use the secondary server as a report server, then the
best is to set up a transactional replication.

--
Ekrem Önsoy



"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:ufIEUtX6HHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
Whell HIlary

In my case the name of database is the same and each one of them are in
diffrent Server

So I did all the part of backup in one server, copy the data and the
log backups to second server and run the restore part on second server

After that i ran the Log shipping again. and it worked fine without no
error.

The now is that the database on secondery server is in Restoring mode
and cannot be accessible.

Whay is that? and this is the situation it should be?
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OMAWABX6HHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Here is an example:
Create database TestRoy
GO
Create database testRoyShipped
GO
alter database testroy set recovery full
GO
alter database TestRoyShipped set recovery full
GO
backup database TestRoy to disk='c:\TestRoy.bak'
GO
restore database [testroyshipped]
from disk = 'C:\TestRoy.bak' with
move 'TestRoy' to
'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\TestRoyShipped.mdf',
move 'TestRoy_log' to
'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\TestRoyShipped_log.LDF',
norecovery, replace
go
backup log testroy to disk='c:\testroylog.bak'
GO
restore log testroyshipped from disk='c:\testroylog.bak' with
norecovery
GO
--
RelevantNoise.com - dedicated to mining blogs for business
intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:eFCIx5V6HHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
Where I do it?
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uWY9TZV6HHA.3828@xxxxxxxxxxxxxxxxxxxxxxx
after you restore your tlogs make sure you use the no_recovery
switch so you can restore more logs.

--
RelevantNoise.com - dedicated to mining blogs for business
intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:%231lEnKV6HHA.5844@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

I got an error when i run restore job:

Database 'some database' is not in Norecovery\standby mode.

what it that means? should i set it on database or in entire
server?

















.

Relevant Pages

  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)