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...

Sqlsavy (11/24/2010)

---

Good Morning!

There are 3 databases for which I am taking log backups all of them were working fine until Monday. One database went into 'Suspect' so I had to...

YTZ (10/29/2010)

---

Adiga & Adam:

Thanks for the reply.

I remember there are 5 log files on SQL Server 2005. Could you offer other three and default location like SQL Server Engin error...