Showing posts with label expert. Show all posts
Showing posts with label expert. Show all posts

Sunday, March 11, 2012

Database restoring problem..HELP!! SOS

I am a noob of SQL2005, when i try to restore my database, it jz doesn't work and i've got this error..any expert here please lend me your hand..thx!!

http://img.photobucket.com/albums/v617/mv2squall_sx/restoredberror.png"

You want to override an existing database which tail has not been yet backuped, which measn that you will lose any changes that were made after the last transaction backup. If you know about that you will either have to confirm it or use another database name.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Friday, February 24, 2012

database recovery

Hi,
I'm no where close to a SQL Server expert but we're using it as a back end
to another application.

I lost a PC that had MS SQL Server 2000. I was able to recover the .MDF and
..LDF files but nothing else. How can I restore these files to another SQL
Server installation on another PC. When I tried to attach them they are not
recognized as valid files (I get the red X instead of the green CHECK).

Is this a basic security function that I'm not going to get around or should
it be possible? Do the .mdf and .ldf files contain specific info about what
PC they were created on?

Are there third party apps that might be able to at least extract the
tables?

Thanks,
WHHi

Try attaching them using from Query Analyser using the sp_attach_db stored
procedure (see Books online)
EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'If that fails you may have to resort to your
database backups.John"WH" <user@.server.com> wrote in message
news:IJsvd.16071$NO5.1938@.twister.rdc-kc.rr.com...
> Hi,
> I'm no where close to a SQL Server expert but we're using it as a back end
> to another application.
> I lost a PC that had MS SQL Server 2000. I was able to recover the .MDF
> and
> .LDF files but nothing else. How can I restore these files to another SQL
> Server installation on another PC. When I tried to attach them they are
> not
> recognized as valid files (I get the red X instead of the green CHECK).
> Is this a basic security function that I'm not going to get around or
> should
> it be possible? Do the .mdf and .ldf files contain specific info about
> what
> PC they were created on?
> Are there third party apps that might be able to at least extract the
> tables?
> Thanks,
> WH