Re: VSS database not opening

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joe Masters (joe.masters_at_dontspamme.com)
Date: 10/19/04


Date: Mon, 18 Oct 2004 19:24:37 -0700

Can your restore the two files from a backup? If you can open it with
ssadmin.exe, you could try to use the archive function and archive the
entire database. Restoring it somewhere else should give you a working
database, although if analyze.exe says that files are corrupt, then the
archive may not work.

Apart from restoring a version of those files that works, you may need to
call Microsoft Product Support for help.

Joe

"Steve K." <anonymous@discussions.com> wrote in message
news:%234BSbtQtEHA.2688@TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a problem opening a database in my VSS 6.
> This particular db is not opening. I took the backup last week, and it was
> successfully completed.
> Now this is not working either. when i try to open it, it does open with
> the
> Admin privileges the first time, but later when I close this,
> it would not open again. It would just hang.
> And without the Admin priv, I cannot open it at all.
>
> I ran Analyze.exe with -F option.
> The analyze.bad file is showing
>
> <path>\data\a\aaaaaaaa
> <path>\data\b\baaaaaaa
>
> So I see that these two files are corrupted. I have even tried disabling
> antivirus on my VSS directories.
>
> Can you tell me how do I create a copy of this database safely , once I
> open
> this thru Admin privileges ?
>
> Or how can I fix these two bad files?
>
>
>
>



Relevant Pages

  • Re: company web user deleted doc
    ... backup exec and the back up ran over the weekend. ... the SQL databases do not get backed up unless you select the ... Those are stored in the MSDE database. ... see Backing Up and Restoring ...
    (microsoft.public.windows.server.sbs)
  • Re: Strategy for backup and restore
    ... > while restoring) cannot do. ... please do your self a favour and correctly backup databases using SQL Server ... that's to say BACKUP DATABASE ...
    (microsoft.public.sqlserver.msde)
  • Re: Potentially corrupt VSS 6.0 database
    ... and are now restoring from our daily ... backup of VSS. ... Is there anything I can do to restore the database? ...
    (microsoft.public.vstudio.sourcesafe)
  • RE: Restore Project Plan to Project Server
    ... Is there anyway to select a single project from the backup medium and saving it to the 'real' database without first restoring the entire database to a temporary database? ...
    (microsoft.public.project.pro_and_server)
  • Re: Backup best practices...
    ... Worst case scenario for each of my customers ... if the server were to sit off for a week: They would use their offline files ... from the backup remote pop3 accounts (that we keep for when COX or SBC ... Try restoring to a new hard drive. ...
    (microsoft.public.windows.server.sbs)