indeed, the order of execution of the log truncation _after_ the diff backup causes the log to be unusefull for recovery purposes.

Maybe a log analyser tool can still recover...

afaik you nolonger need the assembly once you have created it in sqlserver.

You can even script it. That will generate a long binary string, but will be portable.

So you can...

I would like a better search engine for SSC.

One that works in general as well as in the "my posts" section.

Maybe add an "extended search" or "search within results" button...

Don't fool yourself nor the engine and define the column using data type datetime !

Rule no 1: tell the system what you know !

Rule no 2: use the correct data...

martinfalch (5/12/2010)

---

Hmm I tried setting up the database using your code, but after running the query from before (this time referring to TimeSeries..SP rather than SP, since the original table...

You are creating a db of 4Gb datafile + 2Gb log file .... to large !

Can you give it a try using this ddl:

CREATE DATABASE [TimeSeriesSSC] ON PRIMARY

(...

Can you script the create database ddl ?

(rightclick on the db-name and then select Script database \ as create \ to query panel and then copy/paste the ddl.)

This will only...

Just my 2ct.

Leave your db as it is until you are 100% sure it is actually over sized !

(Someone will have put it to that size for a reason, figure...

Your db files are >= 4Gb, which is the maximum for sql2005 express edition.

You'll need to free up some space before your engine will be able to allocate it.

You'll have...

another thing ...

Are you sure your instance is listening at the port number you provided ??

If I'm correct, in a connection string, if you provide the port number, it will...

file 1 is a data file.

Shrinking it 500MB at a time will be to much overhead for your operation, especially if you know it only contains 20% worth of data.

I...

You could use a server level DDL trigger in combination with a database set AUTO_CLOSE on.

(check BOL DDL Statements with Server Scope (ALTER_DATABASE) )

and just register if it is...

afaik you cannot delete a part of a backup file.

A backup device is just a pointer to an actual file.

If you use backup with init, that file wil...

That shouldn't be a problem.

please check out Identifiers http://msdn.microsoft.com/en-us/library/ms175874.aspx regarding your table name containing the #.

Avoid special chars in your object names or always use brackets ([ ]) with your...

the lack of indexes, clustering indexes and foreign keys will indeed kill this kind of queries.

Determine a primary key for every table and if you can, determine foreign keys that...