usually the other way, Production database can be restored to Dev

I will elaborate my scenario"

1. We have a 3 node active/passive/active cluster setup. Node1(A), Node2(P), and Node3(A)

2. Node1 should fail over to node2 and node3 should fail to node3.But not...

So, You want me to add the Back drive in SQL group too??? that's the you configured?

Right now the server is in production. If I want to add the backup...

Thanks,

I don't understand why you would design it this way? Back it up to a UNC path or to the shared SAN drive. Don't see what this acheives other than...

Yes Steve, Can we backup the same database to two different servers at the same time?

Thank you..

one more question..Do you take the Tape backups of Differential and log backup files too? Is that necessary.

Because currently we are taking the Tape Backups after the full backup...

Thank you,

I have couple of questions here.

1.In sql server 2000 all the logins were created using SQL Server Authentication, with a username and password.

If I choose windows authentication while installing...

Yes, Iam able to restore the database.I copied the the fullbackup of the database to a test server and did the restore and its worked.

I followed the Paul's Recommendation as below:

My recommendation in this case is as follows, with the understanding that your log backup chain will be broken (it's broken anyway because part...

hi,

After the SAN outage, we restrated the server.As soon as the server is restarted, the scheduled log backup job was ran and resulted with the below error:

Backup detected log...

Thanks for all your help..

Actually Our SAN had problems and all the production server got shutdown.When we restarted the servers , our scheduled log backup failed and then I checked...

The database online and its running normally, I mean not in suspect mode. Is this the sign of good database?

Thanks Gail,

is the log corruption in the database is different from databse corruption? I ran DBCC CHECKDB and did not give me any errors.After the DBCC CHECKDB, I took...

I ran dbbc checkdb, it did not give any errors. So Iam in safe orI need to check any other important items.please advise me..

SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')); and its showing output as DISABLED.

What this mean? we have sql server 2000 standard edition with SP4