Separate from the full backup?

Didn't we have a discussion on the transaction log in another thread...

Leo (10/22/2008)

---

Hello Gila,

The table size has nothing to do with the transaction log. If the transaction log is not huge, then it's not a transaction log problem.

Transaction Log...

What does SELECT @@version return?

DTA shouldn't be run from the server. It puts additional load on the server. For that matter, it shouldn't be run against a production server. It...

The table size has nothing to do with the transaction log. If the transaction log is not huge, then it's not a transaction log problem. You should not consider setting...

That's not a standard SQL Server error. There's also no way that a select statement alone will give a foreign key/null/unique constraint error. Those can only be thrown by an...

Where's the primary key?

Do you reload the entire 10.5 million rows every day, or are you doing incremental loads?

With profiler, the default template's pretty good, just make sure that you...

Upington? There are people living there? 😉

It's a possibility. I'd have to ask MS though, as I have no tools for doing that myself. Also we'd then have to consider...

What error do you get?

With the variables declared it parses fine. I can't run it, because I don't have your tables

DECLARE @CompanyId int, @AuthRolId int, @UserId int

SELECT tblProjects.ProjectId, tblProjects.ProjectName,...

The_SQL_DBA (10/21/2008)

---

If this is not a critical DB and you have issues with disk space then you could go for BULK LOGGED RECOVERY Model, here you cannot do a point...

Check that your log backups are succeeding.

What's the result of this query for the DB in question

SELECT name, log_reuse_wait_desc from sys.databases

That's a pretty open-ended question. Can...

MySpace runs on SQL Server, so it's not a case of can SQL handle it, it can, but also the rest of the infrastructure needs serious consideration.

Will your network support...

DBCC SQLPERF(LogSpace) isn't deprecated in SQL 2008. There's no deprecation notice in BoL and running it doesn't fire a deprecation event for profiler to pick up.

TheSQLGuru (10/21/2008)

---

You could also decide to switch to a NON-clustered index here, which should be able to rebuild online since it would not contain the 'bad' column. Not...

Can you post the table structure and some of the more common queries that are run against it? Use profiler to get an idea of the queries that Access runs...