hi,
is there any SP or Tsql statment can read the logical
files name from backup files.
I know i can use RESTORE FILELISTONLY but i need to access
the files name and use them on a script.
regards,
AymanFrom what script do you want to access this information? Whatever you use,
you will have to make a connection to SQL Server, to run RESTORE
FILELISTONLY command.--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"ayman" <ayman.massri@.ihorizons.com> wrote in message
news:a1cf01c3ebfe$cb13d140$a101280a@.phx.gbl...
hi,
is there any SP or Tsql statment can read the logical
files name from backup files.
I know i can use RESTORE FILELISTONLY but i need to access
the files name and use them on a script.
regards,
Ayman
Showing posts with label logical. Show all posts
Showing posts with label logical. Show all posts
Friday, March 23, 2012
Monday, February 20, 2012
RB - Logical Primary Key
There is a Set Logical Primary Key option in DSV. Curious as to what is the Logical Primary Key. What is it behind the scene?Where does the logical PK reside? Is there going to be a performance difference using the logical PK?
Subscribe to:
Posts (Atom)