Well then be glad you havent come across this mix! Im not running R2 but am running ssms 2008 (patched) and can access our 2000, 2005 servers with no probs...

sqlapprentice (1/27/2011)

---

sgodrich (1/27/2011)

---

I just solved the same problem on our servers by running (the now depreciated but still accepted) command:

netsh firewall set service RemoteAdmin enable

From a command prompt set to...

the.hank (1/14/2011)

---

i had taken relevant data to another server and than deleted those data from my server because the size in my server was less. but the size of mdf...

You said the size exceeded, but exceeded what?

The simple answer is do a full backup and follow up with a database and log shrink.

HOWEVER it is reallly concerning that you...

True but from the posters first post it seems they are worried about log filling (and presumably subsiquent growths) during the night.

Unless you change the ricovery model and then run your reindex (buts it is not advisable).

Why is this an issue? Do you not have enough disk space?

Not sure i understand.

You would need to restore your last full backup (.bak), then re-apply (restore) each log backup (.trn) up until the failure.

If you dont have a log backup...

Just so that im clear, you now have the required code to check for an enabled or disabled mirror, right?

As far as database names and server names are concerned, I...

javen-718435 (12/28/2010)

---

This seems to be hardwired in Management Studio (all versions), there does not seem to be anywhere (even a registry hack) to alter this. Which seems strange as...

How do you mean, what dont you get?

Can you connect to the SQL server instance that your mirror is to be...

ionas (12/6/2010)

---

Basically I have two options for SQL service:

1.Built in account (Network service, Local system, Local service)

2.This account

Cuurently, I use first option and "Local system" but the drive is not...

Check to see that the 'mirror' server is reachable from your 'principal' (ie rdp to it and go into ssms and try to connect).

Ensure that the account you are trying...

Heya,

Heres a few suggestions:

1. What have you done to test?

2. Do you have plenty of space on your App drive (generally c: if not changed at install or registry)?

3. Have...

Glad to help 🙂

If you right click on database and pick rename, does the name have a leading or trailing space?

The other thing to try is to create a new maint plan, it...