Re: Restore database

Hello,

Can you take a full database backup again from the SQL Server 2005 machine
and then try restoring in SQL Express.
Initialize the backup device with INIT. Use the below format.

BACKUP DATABASE <DBNAME> to DISK='D:\Backup\Dbname.bak' WITH INIT,Stats=1

Thanks
Hari

"Markgoldin" <markgoldin@xxxxxxxxxxx> wrote in message
news:C6BF147C-478F-41C0-981A-C05C6BB75DF0@xxxxxxxxxxxxxxxx
Backup file is just 2 mg,
I am running SQL 2005 Express on Vista Business.

"Brett I. Holcomb" <brettholcomb@xxxxxxxxxxxxx> wrote in message
news:uVHgMbxoHHA.5084@xxxxxxxxxxxxxxxxxxxxxxx
How small is small and what kind of system do you have?


Markgoldin wrote:
Unless I did something wrong, it has been 30 min, that it is still
saying "restoring". My database is very small.
Should it take that long?


"Brett I. Holcomb" <brettholcomb@xxxxxxxxxxxxx> wrote in message
news:eak99nwoHHA.596@xxxxxxxxxxxxxxxxxxxxxxx
Evidently there is a log that's not backed up - or part of it.

You can backup the log if it's still around or if you know for sure
that there aren't any transactions in the log that you need you can use
the options listed in the error to force it to restore the
database -BUT be VERY sure the missing log doesn't have something you
need.


Markgoldin wrote:
I am trying to restore database from SQL 2005 to SQL 2005 Express.
I am getitng an error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'HOMEDEV\SQLEXPRESS'.
(Microsoft.SqlServer.Express.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 -
-----------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The tail of the log for the database
"accidents" has not been backed up. Use BACKUP LOG WITH NORECOVERY to
backup the log if it contains work you do not want to lose. Use the
WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just
overwrite the contents of the log. (Microsoft.SqlServer.Express.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
Can someone help, please?

--
Brett I. Holcomb
brettholcomb@xxxxxxxxxxxxxxxxx
Remove R777 to email


--
Brett I. Holcomb
brettholcomb@xxxxxxxxxxxxxxxxx
Remove R777 to email



.

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: SQL server restore
    ... there is possiblly a database ... As for the SQL Server 2000 work on the Server A, ... restore the backups on it. ... restore from the backup). ...
    (microsoft.public.sqlserver.server)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: restore permissions to a login
    ... restore the database. ... what about SQL Server installations that use ... > I have run into a situation that a 3rd party backup and restore solution ... > database roles and database_creators server role. ...
    (microsoft.public.sqlserver.server)