Brandie is referring to (I think) when you take a backup of a database, that information (database name, timestamps, file name and path) are kept in system tables. When...

The upper management should decide how much data can be lost. They would be more familar with the business needs of that data. As well it lifts the...

I can't advise you to do it;-), but I have had to go through and delete the existance of the node name in the registry so it would let me...

No problem. I don't mess with cluster admin much, I'm usually involved after the OS side is setup....

http://support.microsoft.com/kb/282227

This has instruction on cleaning up a cluster service, basically removing the node from the cluster.

To remove the groups you will need to take the node offline and then I...

If this is a test setup I would probably just start over, unless something dictates otherwise I prefer to start clean instead of bandaiding something (especially if it is just...

Cory would be correct.

You will break that session (CTRL + C) and close that command prompt window. Then just start services back using the SQL Configuration Manager console.

THE-FHA (4/14/2010)

---

EXECUTE master.dbo.xp_delete_file 0,N'D:\BackupFolder',N'BAK',@DelDate, 1

LET'S SAY I WANT TO DELETE TODAYS BACKUP just to test if you script works.

send me your code.

One more thing do i put the backup and...

How did you put it in single user mode?

NEW TO SQL (4/26/2010)

---

Please suggest me to method to start the mssql 2005 instance back in multi-user mode.

i ran the instance in single user mode and now wondering how to...

Do you want to remove the group just because it didn't fail-over or is the error on why it failed leading you to something?

What OS version are you running?

You would need to verify that the network name of the SQL instance is accessible. If you can access it by entering the IP address then there is probably...

You don't actually do a "tail log backup" on a schedule, it is a "Log Backup". A tail log backup is done during recovery steps.

You can do this in...

http://msdn.microsoft.com/en-us/library/ms143515(v=SQL.90).aspx

Actually took me a while to Google...

There are a good number of things that can cause high CPU usage.

What steps have you taken already to troubleshoot the issue? Can you provide more details on how...