lost Files (on Flash Memory)

• farzad Rahmani

  Valued Member

  Points: 55

  More actions

  July 23, 2007 at 11:49 pm

  #177677

  Hello,

  i have created a database in SQL Server 2005 with following files and filegroups:

  C:\testDB\test.mdf  on Primary filegroup

  H:\TestDB\test1.ndf on FG1 filegroup

  C:\testDB\test_log.ldf

  Note that H:\ is a removeable USB Flash Disk.

  then i try to create a table on each of these filegroups

  create table tbl1(col1 int identity, col2 char(1) default 'a') on 'Primary'

  create table tbl2(col1 int identity,col2 char(1) default 'b') on FG1

  now i try to insert a couple of records in each table.

  insert into tbl1 default values

  insert into tbl1 default values

  insert into tbl2 default values

  insert into tbl2 default values

  after that i removed the flash disk. then i send this command

  select * from tbl2

  I didn't Believe it. it worked. not only this but also, any other command which needs to access data files worked (insert, update, delete, create index , ....)

  even dbcc checkdb works well. but checkpoint dosn't work. 

  as soon as i restarted SQLServer Service, the database marked as suspected and i need to recover it.

  now, what is the theory behind this action. where the data comes from when the data file is not ready?

  any help will be appreciated

  thanks in advance

  Farzad

   

  ---

  Kindest Regards,

  farzad Rahmani
  

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 24, 2007 at 2:51 am

  #721810

  cross post!!!!!!!!!!!

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com