| Author |
RESTORE FILELISTONLY
|
|
| childofthe1980s 2006-10-25, 6:00 am |
| Hello:
SQL Server 2005 is giving me syntax errors when I run the script below
against the master database. Could someone please let me know what I'm doing
wrong?
Thanks!
RESTORE FILELISTONLY [TWO]
FROM DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\Backup\TWO_0
82106PM.bak'
| |
| Hilary Cotter 2006-10-25, 6:00 am |
| Does this work?
RESTORE FILELISTONLY [TWO]
FROM DISK = N'C:\"Program Files"\"Microsoft SQL
Server"\MSSQL. 1\MSSQL\Backup\TWO_0
82106PM.bak'
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"childofthe1980s" < childofthe1980s@disc
ussions.microsoft.com> wrote in
message news:74CBFE09-D795-49E3-8CDD- 1016466B3163@microso
ft.com...
> Hello:
>
> SQL Server 2005 is giving me syntax errors when I run the script below
> against the master database. Could someone please let me know what I'm
> doing
> wrong?
>
> Thanks!
>
> RESTORE FILELISTONLY [TWO]
> FROM DISK = N'C:\Program Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\Backup\TWO_0
82106PM.bak'
| |
| childofthe1980s 2006-10-25, 6:00 am |
| No, I'm afraid that did not work. I got an "incorrect syntax near
FILELISTONLY" error.
"Hilary Cotter" wrote:
> Does this work?
>
> RESTORE FILELISTONLY [TWO]
> FROM DISK = N'C:\"Program Files"\"Microsoft SQL
> Server"\MSSQL. 1\MSSQL\Backup\TWO_0
82106PM.bak'
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "childofthe1980s" < childofthe1980s@disc
ussions.microsoft.com> wrote in
> message news:74CBFE09-D795-49E3-8CDD- 1016466B3163@microso
ft.com...
>
>
>
| |
| Kalen Delaney 2006-10-25, 6:00 am |
| What's the [TWO]?
Look at the syntax for RESTORE FILELISTONLY, here's an example:
RESTORE FILELISTONLY FROM AdventureWorksBackup
s
WITH FILE=2;
GO
You do not specify a database name, if that is what [TWO] is supposed to be.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"childofthe1980s" < childofthe1980s@disc
ussions.microsoft.com> wrote in
message news:07137D09-9135-4654-A45B- 9E6464261345@microso
ft.com...[color=darkred]
> No, I'm afraid that did not work. I got an "incorrect syntax near
> FILELISTONLY" error.
>
> "Hilary Cotter" wrote:
>
| |
| childofthe1980s 2006-10-25, 6:00 am |
| Thanks, Karen! I finally got the syntax right as follows:
RESTORE filelistonly
FROM DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\Backup\TWO_0
82106PM'
"Kalen Delaney" wrote:
> What's the [TWO]?
> Look at the syntax for RESTORE FILELISTONLY, here's an example:
>
> RESTORE FILELISTONLY FROM AdventureWorksBackup
s
> WITH FILE=2;
> GO
>
> You do not specify a database name, if that is what [TWO] is supposed to be.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
>
> "childofthe1980s" < childofthe1980s@disc
ussions.microsoft.com> wrote in
> message news:07137D09-9135-4654-A45B- 9E6464261345@microso
ft.com...
>
>
>
|
|
|
|