Re: SQL SERVER 2005 x64 SP3 and Windows Server 2008 R2 X64

Tech-Archive recommends: Fix windows errors by optimizing your registry

Andrew just to give you more info you acctually select the databases when you
setup the backup. So it shows you the sql icons to represent the database.

Then when you go to sql logs and windows logs it says sql database
succesfully backed up.

I might be wrong about the plug in though it might be sql's sql-writer
because sp3 enables it.

However that still leaves the problem of successfully restoring it even
though it says it is succesfully backed up.
--
General System Admin and IT manager


"Andrew J. Kelly" wrote:

If there is a plug-in for Win2008 I haven't heard of it. I would check to be
sure there isn't a SQL Agent job that is actually doing the backup. But
there is simply no way you can backup a folder and get a successful SQL
Server backup.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Ricus" <Ricus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:86156AD3-60F9-434B-A389-1998D5834821@xxxxxxxxxxxxxxxx
We have setup a new server with W2k8R2x64 and SQL 2005x64 SP3.My sql data
and log folders are on two seperate mount points. In Windows server backup
we
specified use a dedicated drive and then selected the folders and did a
one
time backup. Now SP3 for sql includes a windows backup plug in as far as I
know since after we selected the sql data and logs folders the backup
successfully completed. This I verified even in sql in the logs where it
says
SQL databases were successfully backed up.

Now my question "HOW DO YOU RESTORE THESE DATABASES WITH WINDOWS SERVER
BACKUP"? When I tried the backup process gace me the folders and I can
only
select the individual file of the 2 file set of sql to restore and then it
fails.

--
General System Admin and IT manager


.

Relevant Pages

  • Re: Backup erros
    ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How do I upgrade/migrate from SQL 2000 (not MSDE) to SQL 2005?
    ... PORTAL SERVER DATA BACKUP ... Be sure to save a complete and full backup using SharePoint's Backup ... BACKUP SQL 2000 DATABASES DIRECTLY THROUGH SQL ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)