Is it your log file that's increased in size rather than your data file?

I've seen this error when the account used for the linked...

Have you done a load of deletes to suddenly free up all this space or was it simply created oversized to start with? I'd want to know why there's...

No. With database mirroring, the mirrored database (on server...

What version of SQL / Windoze are you running, 32-bit or 64-bit?

What are your memory settings for AWE, boot.ini and so on?

Good news. You don't need the Enterprise edition (2k5) to get logshipping (and mirroring). Just get SQL2005 Standard Ed. Logshipping is then a few mouse clicks away....

To confirm this is a permissions problem, set the share and NTFS permissions on the remote backup folder to "Everyone" - Change Control / Modify

Then try and re-run the backup.

What is in the ldf file

If the database is in full mode:

Every transaction is first written to the log then (on commit transaction) committed to the database (mdf file). ...

It depends. If the transaction is open and you stop SQL and delete the transaction it will "lose" the data in the transaction log (because you just deleted it)....

When you create your FTC, what are you setting the populate frequency to?

As others have said, no backup means the ldf file is useless.

You're going to have to get the database back via a 3rd party who specialise in data recovery. ...

venkat (11/17/2008)

---

If the user complaint you that application is running very slow. As a DBA where do you start your work ???how do you find where exactly the problem is???...

I've seen SQL servers do this before and it has (as others...

Yes(ish) but you need to do the failover bit in your C# or VB code.

Try (connect to serverA, mydb)

Catch (connect to serverB, mydb)

That sort of thing. 😀

I couldn't be sure without testing somewhat but my gut instinct tells me that SQL will compare two decimals quicker (eg where Var1 = Var2) than two chars hence I...