sp_create_removeable

• Alex Wilson-148544

  SSC-Addicted

  Points: 470

  More actions

  October 21, 2004 at 4:22 am

  #112457

  Hiya,

  Im trying to create a read-only database on removeable media for archive purposes...

  I have issued a sp_create_removeable, successfully, copied the data I want to archive into it, I am now having two problems:

  Problem #1

  sp_certify_removeable, returns 'invalid object sysdatabases', i am definately running this in the master context, I cant see why, it cannot find sysdatabases.

  Problem #2

  this is more of a confusion than an error, once I have run sp_certify_removeable, what files do I then copy to CD, the MDF, the NDF ? I was under the impression that system objects are put in a seperate file, becasue they do not need to be copied to CD (am i wrong?)

  My Code Follows:

  sp_create_removable

   @dbname  = 'Southwind',

   @syslogical  = 'sysSouthwind',

   @sysphysical  = 'c:\Temp\Southwind_sysdata.mdf',

   @syssize = 2, 

   @loglogical = 'sysloglSouthwind',

   @logphysical = 'c:\Temp\Southwind_log.ldf',

   @logsize = 4,

   @datalogical1 = 'dbSouthwind',

   @dataphysical1 = 'c:\Temp\Southwind_dbdata.ndf',

   @datasize1 = 10

  sp_certify_removable  

   @dbname = 'Southwind' ,

   @autofix = 'auto'

   

  TIA,

  Alex

• October 25, 2004 at 8:00 am

  This was removed by the editor as SPAM

• ishiim

  Newbie

  Points: 3

  More actions

  June 15, 2005 at 6:28 pm

  #565948

  I received the same message 'invalid object sysdatabases,' but I went ahead with the rest of the procedure and everything else worked just fine, so it *appears* that this message can be ignored. Specifically:

  1) Used sp_create_removable to create the database

  2) Used DTS to copy data from another database into the removable media DB

  3) Made sure connections were clear, then ran sp_certify_removable. The error message comes up, but a refresh in Enterprise Manager shows it offline and ready for copying.

  4) Copied to the removable media, and in my example, a read-only media

  5) Took to a new instance and copied the small MDF fiile from the removable media to the hard drive, and made sure it was NOT read-only.

  6) Used Attach Database to point to the MDF file on the hard drive, which in turn point to the correct NDF and LDF files on the read-only removable media

  7) These attached fine and show up as a read-only database in EM, and is queryable.

  So long story short, I simply ignore the 'invalid object sysdatabases' message and proceed along.

  --Michael