Lowell (4/26/2010)

---

i had a little trouble reading what you wanted, but i think i got it.

1. you want to create a view for every table in the database, but exclude...

There is nothing in that script that would cause the issue you are having. It has to be some other script that is breaking the log chain.

Two questions:

1) Why...

Review the article again - it shows you.

I don't see where you are wexecuting the dynamic sql. Either way, '' is not the same as null.

I would check all scheduled jobs, and any scheduled jobs that ran right before this issue happened. I would also check the SQL Server logs to see if the...

Krasavita (4/25/2010)

---

Here is errror:

Executing the query "BACKUP LOG [Jul_reports] TO DISK = N'F:\\TransactionJobs\\Jul_Reports\\jul_Reports_backup_201004251500.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'Jul_Reports_backup_20100425150007', SKIP, REWIND, NOUNLOAD, STATS...

How do you know it is failing? You state there are no errors, where have you looked?

Is this a maintenance plan job? If so, View History for the...

Generally, the approach that is taken is to update the row and specify all of the column values. In your application, you would get all of the data -...

Start with this article: http://www.sommarskog.se/dyn-search-2005.html

First, how often do you backup your transaction log?

Second, do you have a max size set for the transaction log?

Review the article in my signature about managing transaction logs -...

Because the maintenance plan recreates the agent job every time you make changes to it and save it.

If you need to log info from a trace, use a server side trace instead of the GUI. A server side trace will run in the background and output...

Perform a new installation instead of modifying an existing one. Then, only select the Reporting Services component.

How are you connecting to the database? If you are using a registered server - check to see what the default setting is for that registered server.

aber (4/23/2010)

---

Thanks, I'll take a look at it. In addition can you help me understand how fragmentation is calculated? I would assume when a reorg or rebuild happens...