To Clarify,

Step (2)

Create a maintenance plan with a Full backup "once" daily and T-Log backups every 15 minutes.

Can someone PLEASE try this and let me know their results.

(1) Create a new database in SQL Server 2000 Enterprise edition. Set to Full recovery model.

(2) Create a maintenance plan...

working good today.

I am restoring the first log backup created after the full backup. There is no overwriting. The maintenance plan creates a different(timestamp) log backup every 15 minutes.

I restore the full,...

This is exactly what I did:

(All done by a maintenance plan.)

10:00pm Full Backup

10:15pm Transaction Log Backup

10:18pm Did some inserts

10:30pm Transaction Log backup

Then I restored the full...

I only started having this problem today. About 90% time I click on ANY topic I see the below message:

"Site Sponsored by 2002 SQLServerCentral.com Reader's Choice Product Voting, SQL...

yep. I just tried the Rebuild.exe and it failed. I am in the process of re-installing SQL Server now.

Why would the sever not start? (It restored fine.)

What is the usual...

this above message appears about 90% time I click on a topic.

They are 2 different servers. The Standby is off-site as I stated above.

Is there a way to recover the standby server?

I have restored a production master over my standby master....

I restored the master to get all my logins over.

Steps I did on Standby Server:

1. Single-User mode.

2. Restored Master.

Now SQL Server won't start.

How can I get my standby server...

The Production is a SQL Server "Named Instance".

Standby is a "Default Instance". Just one instance on this box.

So I used a named instance master backup and restored it to...

any information on this in BOL or anywhere else? I can't find any.

BOL:

When you grant an object permission to a user account in a database, you can optionally specify the WITH GRANT OPTION clause, which allows the user account to grant that...

It is actually there in the create database screen, collation name...

I was looking in Books Online and thats where it does not exist.

THANKS!!!

ya thats the setting I have checked.