ps (6/19/2009)

---

yes restore in norecovery mode. and you cannot backup log if your source database is not in FULL recovery mode.

restore the full backup in norecovery mode and restore the...

Do you mean restore in recovery mode?

I follow document: set DB Recovery model Full and use norecovery mode

Yes, your way is the same as mine

I test with Northwind DB and backup to NW2 DB in the same server

1) Backup and restore DB

BACKUP LOG Northwind WITH TRUNCATE_ONLY

WAITFOR DELAY...

No, it's small test DB that I created, no one than me use it

After first time I run BACKUP LOG/RESTORE LOG successfully, the next time I get error:

Processed 1 pages...

When I rerun I get this error

Server: Msg 5064, Level 16, State 1, Line 1

Changes to the state or options of database 'NW2' cannot be made at this time. The...

I already switch to Master DB in SQL Analyzer before I get this error :sick:

I use "alter database ... set single_user with rollback immediate" instead of "EXEC sp_dboption.."

But when I restore LOG:

RESTORE LOG NW2

FROM DISK = 'c:orthwind_log.bak'

WITH

DBO_ONLY,

STANDBY = 'c:\NW2\undo_NW2_log.ldf

I get error:

Server: Msg 3101,...

I find very userfull document step by step to do http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

But when I restore DB

RESTORE DATABASE database_name

FROM DISK = 'g:\mssql7\backup\database_name\database_name_backup_device.bak'

WITH

DBO_ONLY,

REPLACE,

STANDBY = 'g:\mssql7\backup\database_name\undo_database_name.ldf',

MOVE 'logical_name' TO 'h:\mssql7\data\database_name.mdf',

MOVE 'logical_name' TO...

ps (6/18/2009)

---

That checkbox is visible in enterprise edition. Can u post the result of this?

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

If you are not running enterprise edition, u'll have to setup...

I use SQL 2000 SP4. I try to create Log Shipping as document but when I use Database Maintenance Plan Wizard in my SQLServer, I don't see option "Ship the...

I use Enterprise edition

ps (6/18/2009)

---

thang_ngo_2002 (6/18/2009)

---

No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we...

Ok, I see, thanks you so much

No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can bring...

Jeffrey Williams (1/1/2009)

---

Database is so big, there are many unused backup tables in database, so I delete them and reduce Database size to easy manage. That's why I want to...