One thing you can check is whether or not replication was setup on that database. It might have been setup and removed, but not completely.

I also suggest you read...

Did you put .bak or just bak for the extension? If the former, this is your problem. You can open the maintenance plan, open the backup task and...

That would depend on the system resources available. I would start by trying to reduce by 50GB at a time. If that takes too long, go with smaller...

Sorry - I misread this, thought you were moving from Production to Test.

Can you explain what you mean when you say you are losing your primary keys? I don't...

You can use Backup/Restore to restore the whole database instead of just the data.

These kinds of issues are generally related to a mis-match between the client tools and the version of the server. Validate the version of the client tools is the...

Has this transaction log ever been backed up? Doesn't sound like it - which is why it is as large as it is.

At this point, I would recommend not...

So, what was the problem and how did you correct it? Maybe someone else will come...

Yes, you have 4 IP addresses assigned. One for each node of the cluster, one for the cluster group and one for the SQL instance.

From the server, open up...

In a windows cluster, you have a Cluster Administrator. This cluster administrator manages the resource groups that have been defined for the cluster.

Each cluster group will be setup with...

That is still the Job History and not the maintenance plan history. The maintenance plan history is going to tell you what task failed and why.

Based upon this message,...

Instead of looking at the agent job history, you need to be looking in the maintenance plan history. Open the maintenance plan folder in Object Explorer, right-click on your...

What are you confused about?

Yes, you can use the virtual IP address for any cluster group that is currently hosted on the same node to access that node through RDP....

Error 5 is an access denied on the file. Make sure the user running SQL Server has full rights on the folder where the file exists.

What do you mean by locked? Are you getting an error?