As far as I'm aware, it can be anywhere in the same filegroup.

varchar doesn't reserve space. If a varchar(4000) column contains only 4 characters, it takes only 6 byes to store (there are two bytes overhead because it's a variable length column)....

It's definitely the backup drive that the errors are complaining about.

Can you monitor the...

Foreign keys are not indexes. If you want an index on the column, you'll have to add one yourself.

Could you explain your problem a little more? How are you viewing the space used by tables?

SQL express doesn't include the agent and therefore can't run maintenance plans.

You can use the windows scheduler to run backup commands (using SQLCMD)

From what I can see from that, your log backups are failing due to insufficient space available on disk. How large is the log and how much space is available...

Don't shrink the database. Shrink just the log file and shrink it...

matt stockham (9/24/2008)

---

Re. inserts ... wouldn't it have to write an entire page of null bytes, so still the same data size?

Logically it shouldn't need to do anything...

Database and backup formats are the same across all architectures (x86, x64, IA64)

Andrew Smith (9/24/2008)

---

Thank you for the reply. Sorry I should have stated that. It's in full mode. I assume your suggesting simple mode to check whether it's old transactions that...

You may want to change the schedule for the log backup so that they run right through the night (rather than stopping at 9pm).

The back ups jobs are sucesseding,...

Have a look at the OUTPUT clause. If I'm understanding you correctly, it'll do what you need.

Duplicate post.

Replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic574925-338-1.aspx

Duplicate post.

Replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic574925-338-1.aspx