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

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 (AT) discussions (DOT) microsoft.com> wrote

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:

OK well SP 3 is required to run SQL 2005 on Win2008 regardless of anything
else so that part is pretty mute. But if you select the databases in a gui
it sounds like it is indeed doing a sql server backup and not a file level
backup. So you should be able to use SSMS or any SQL tsql command line
utility to issue a restore database command. Most all plug-ins simply issue
a BACKUP xxx command with the proper parameters. If the tool has the
ability to backup I suspect it can also restore as well but I have not seen
this tool before so I can't say for sure. But you can find the backup files
it creates and try restoring them to another instance or with a different
name on this instance to verify you can in fact do it.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Ricus" <Ricus (AT) discussions (DOT) microsoft.com> wrote

Unfortunately WINDOWS SERVER BACKUP stores it in its own format so I cannot
see the db files.

Just to recap though the backup utility I am referring to is MS 's own
backup utility coming with windows server 2008.
--
General System Admin and IT manager


"Andrew J. Kelly" wrote:

OK it appears that Win2008 has a utility to allow VSS backups and since SQL
Server supports VSS it must be included. This is NOT a normal SQL backup and
you would have to use the same software that you took the backup with to
issue a restore. This is more of a snapshot type of backup and does not
allow you to do point in time recovery on it's own. You would still need to
take regular log backups for that. If periodic snapshots or diffs are ok
for your requirements then this may be OK. This might help some.

http://www.wbadmin.info/articles/how...ckup-work.html


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Ricus" <Ricus (AT) discussions (DOT) microsoft.com> wrote