GilaMonster (9/24/2010)

---

Unfortunately not. 😉

That was also during a power failure. I have 2 UPSs for the computer, TV, xbox and ADSL...

I like picture 3 : Finaly computer romance :hehe:

How about this:

use tempdb

go

drop table T3

go

drop table T2;

go

drop table T1;

go

drop proc usp_new_T1

go

Create table T1

( col1 int identity(1, 1)

...

Should we alter our default replies to

"press F1 for solution", "press shift+F1 for urgent solution" :w00t:

GilaMonster (9/23/2010)

---

ALZDBA (9/23/2010)

---

Msg 8921, Level 16, State 1, Line 2

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check...

very, very sad indeed

use master

dbcc checkdb ( theotherdb ) with tablock

go

Msg 8921, Level 16, State 1, Line 2

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...

that results into:

PAGE: (1:19170)

BUFFER:

BUF @0x000000008FFF0400

bpage = 0x000000008FC10000 bhash = 0x0000000000000000 ...

use Anotherdb

print db_id()

go

11

dbcc checkdb ( Anotherdb )

go

Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...

Since you asked for it 😉

Msg 8928, Level 16, State 1, Line 1

Object ID 53575229, index ID 1, partition ID 72057594039697408, alloc unit ID 72057594043695104 (type LOB data): Page (1:507)...

Oh yes, Dev Edtn vs Ent Edtn in licensing terms will vary more than a decent hardwares cost.

GilaMonster (9/22/2010)

---

I am seriously contemplating submitting a...

... dev data ...

If you are using a sql server developer edition (2005/2008) have a look a database snapshots as they may come in handy to retain "the morning...

How's that for a party killer 😀

Another way is using SQLCMD.

btw The solutions you are looking for in this thread are actually only exporting / importing data.

It takes more to be considered a solid backup strategy...