Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.Install SQL Server again. Then use the RESTORE DATABASE command to restore your database backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a401280a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>

Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.Install SQL Server again. Then use the RESTORE DATABASE command to restore y
our database backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a40128
0a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>|||Install SQL Server again. Then use the RESTORE DATABASE command to
restore your
database backups.
I did that. Choosing Database, in Parameters, there's no 'First backup
to restore' shown and I'm required to select a backup to restore.
Choosing Filegroups of files instead of Database, I 'Select a subset of
backup sets' and for Selection Criteria, I select 'Only the backup sets
of the data files on drive F, and get this message: 'The current filter
excludes all existing backup sets. Change the filter to include at least
one backup set,' Checking, additionally, 'Only the backup sets completed
after 04/28/2004' (the last backup was on 04/29/2004), I get the same
message. Selecting 'Only backup sets of the following filegroups and
files', I can't enter the names of the filegroups and/or files.
If I select the F: drive where the files are saved in F:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\Data\DataFiles_Data.MDF, I'm
informed that it's not a valid Microsoft Tape Format backup set.
'RESTORE DATABASE is terminating abnormally'. '?
Could you help? I'm new at this!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.
Install SQL Server again. Then use the RESTORE DATABASE command to restore your database backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a401280a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>
|||Install SQL Server again. Then use the RESTORE DATABASE command to
restore your
database backups.
I did that. Choosing Database, in Parameters, there's no 'First backup
to restore' shown and I'm required to select a backup to restore.
Choosing Filegroups of files instead of Database, I 'Select a subset of
backup sets' and for Selection Criteria, I select 'Only the backup sets
of the data files on drive F, and get this message: 'The current filter
excludes all existing backup sets. Change the filter to include at least
one backup set,' Checking, additionally, 'Only the backup sets completed
after 04/28/2004' (the last backup was on 04/29/2004), I get the same
message. Selecting 'Only backup sets of the following filegroups and
files', I can't enter the names of the filegroups and/or files.
If I select the F: drive where the files are saved in F:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\Data\DataFiles_Data.MDF, I'm
informed that it's not a valid Microsoft Tape Format backup set.
'RESTORE DATABASE is terminating abnormally'. ??
Could you help? I'm new at this!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Retrieve the logical file name from a backup device

Hi,
I'm working on some "daemon" able to restore whatever come into a given
folder to a "stand-by" SQL Server (sort of log shipping, but also to restore
full backup and so on).
I'm now faing a problem : I can't put the logical name of the database from
the backup file to a variable.
Here a sample of what I 'm trying to do :
--
DECLARE @.Data_file nvarchar (256)
create table #result
(
LogicalName varchar(512),
PhysicalName varchar(512),
Type varchar(1),
FileGroupName nvarchar(50),
Size int,
Maxsize int
)
insert into #result EXEC (restore filelistonly from disk='X:\file.bak')
--
(please note that table declaration, variable delclaration, etc may be
weird, but it's purely test code to try validate my concept.
Each time I got the following error :
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'restore'.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
As RESTORE filelistonly is, from BOL, returning a dataset, I was expecting
to be able to load into a table, or to be able to extract data from it
easily.
I do not know where to look at, any help will be welcome,
Thanks,
ChrisSee "RESTORE FILELISTONLY " in BOL.
AMB
"Chris V." wrote:

> Hi,
> I'm working on some "daemon" able to restore whatever come into a given
> folder to a "stand-by" SQL Server (sort of log shipping, but also to resto
re
> full backup and so on).
> I'm now faing a problem : I can't put the logical name of the database fro
m
> the backup file to a variable.
> Here a sample of what I 'm trying to do :
> --
> DECLARE @.Data_file nvarchar (256)
> create table #result
> (
> LogicalName varchar(512),
> PhysicalName varchar(512),
> Type varchar(1),
> FileGroupName nvarchar(50),
> Size int,
> Maxsize int
> )
> insert into #result EXEC (restore filelistonly from disk='X:\file.bak')
> --
> (please note that table declaration, variable delclaration, etc may be
> weird, but it's purely test code to try validate my concept.
> Each time I got the following error :
> Server: Msg 156, Level 15, State 1, Line 1
> Incorrect syntax near the keyword 'restore'.
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near ')'.
>
> As RESTORE filelistonly is, from BOL, returning a dataset, I was expecting
> to be able to load into a table, or to be able to extract data from it
> easily.
> I do not know where to look at, any help will be welcome,
> Thanks,
> Chris
>
>|||Hi Alejandro,
That's what I;ve done, bout couldn't find the way to have the following
result :
SELECT @.DATE_FILE =SELECT LogicalName from EXEC(RESTORE FILELISTONLY from
DISK='File') where TYPE='D'
I'm desperate :)
Thanks,
Chris
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> a crit dans le
message de news:99C7DE87-8022-4F37-A797-F99296625772@.microsoft.com...
> See "RESTORE FILELISTONLY " in BOL.
>
> AMB
> "Chris V." wrote:
>
restore
from
expecting|||Try,
use northwind
go
create table #t (
LogicalName sysname,
PhysicalName sysname,
Type char(1),
FileGroupName sysname null,
[Size] bigint,
[MaxSize] bigint
)
insert into #t
execute sp_executesql N'use master restore filelistonly from mydump'
select
*
from
#t
drop table #t
go
AMB
"Chris" wrote:

> Hi Alejandro,
> That's what I;ve done, bout couldn't find the way to have the following
> result :
> SELECT @.DATE_FILE =SELECT LogicalName from EXEC(RESTORE FILELISTONLY from
> DISK='File') where TYPE='D'
> I'm desperate :)
> Thanks,
> Chris
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> a écrit dans l
e
> message de news:99C7DE87-8022-4F37-A797-F99296625772@.microsoft.com...
> restore
> from
> expecting
>
>|||Works perfectly !
Thanks
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:E686C7EB-957F-4A14-BEA2-6C86F80B1D3F@.microsoft.com...
> Try,
> use northwind
> go
> create table #t (
> LogicalName sysname,
> PhysicalName sysname,
> Type char(1),
> FileGroupName sysname null,
> [Size] bigint,
> [MaxSize] bigint
> )
> insert into #t
> execute sp_executesql N'use master restore filelistonly from mydump'
> select
> *
> from
> #t
> drop table #t
> go
>
> AMB
> "Chris" wrote:
>
from
le
given
database
disk='X:\file.bak')
be
it