Hi All,
Can anyone tell me if there is any system table/view/SP available where I
can query to view the path of a database backup file when the last database
backup is taken?
For example I can find the backup information(like backup begin start date,
backup finish date, etc) of a database using msdb.dbo.backupset. I am
looking for something similar query where I can see the location, either to
tape, device, or any local directory, of the backup.
Thanks a lot,
VM
Take a look at the backupmediafamily table in msdb. The
columns Physical_device_name and device_type tell you what
device and path was used for the backup.
-Sue
On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Can anyone tell me if there is any system table/view/SP available where I
>can query to view the path of a database backup file when the last database
>backup is taken?
>For example I can find the backup information(like backup begin start date,
>backup finish date, etc) of a database using msdb.dbo.backupset. I am
>looking for something similar query where I can see the location, either to
>tape, device, or any local directory, of the backup.
>Thanks a lot,
>VM
|||There is a child table of backupset called backupfile that contains the
information you need. Look up System tables in BOL. Choose All Databases
as the subtopic. Scroll down to the section called "Tables in the MSDB
database" for more details.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> Hi All,
> Can anyone tell me if there is any system table/view/SP available where I
> can query to view the path of a database backup file when the last
> database
> backup is taken?
> For example I can find the backup information(like backup begin start
> date,
> backup finish date, etc) of a database using msdb.dbo.backupset. I am
> looking for something similar query where I can see the location, either
> to
> tape, device, or any local directory, of the backup.
> Thanks a lot,
> VM
|||Thanks Sue! It worked.
VM
"Sue Hoegemeier" wrote:
> Take a look at the backupmediafamily table in msdb. The
> columns Physical_device_name and device_type tell you what
> device and path was used for the backup.
> -Sue
> On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
> <VM@.discussions.microsoft.com> wrote:
>
>
|||Thanks for Information Geoff. I was looking for backupmediafamily table.
VM
"Geoff N. Hiten" wrote:
> There is a child table of backupset called backupfile that contains the
> information you need. Look up System tables in BOL. Choose All Databases
> as the subtopic. Scroll down to the section called "Tables in the MSDB
> database" for more details.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
>
>
|||Sue was right with backupmediafamily. I should have looked at my backup
management code instead of writig from memory. Either way, the information
in BOL is very useful.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:5E526962-6D6A-4827-8EAE-FBA04E9EF8CD@.microsoft.com...[vbcol=seagreen]
> Thanks for Information Geoff. I was looking for backupmediafamily table.
> VM
> "Geoff N. Hiten" wrote:
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
Tuesday, March 20, 2012
Path of the backup file
Hi All,
Can anyone tell me if there is any system table/view/SP available where I
can query to view the path of a database backup file when the last database
backup is taken?
For example I can find the backup information(like backup begin start date,
backup finish date, etc) of a database using msdb.dbo.backupset. I am
looking for something similar query where I can see the location, either to
tape, device, or any local directory, of the backup.
Thanks a lot,
VMTake a look at the backupmediafamily table in msdb. The
columns Physical_device_name and device_type tell you what
device and path was used for the backup.
-Sue
On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Can anyone tell me if there is any system table/view/SP available where I
>can query to view the path of a database backup file when the last database
>backup is taken?
>For example I can find the backup information(like backup begin start date,
>backup finish date, etc) of a database using msdb.dbo.backupset. I am
>looking for something similar query where I can see the location, either to
>tape, device, or any local directory, of the backup.
>Thanks a lot,
>VM|||There is a child table of backupset called backupfile that contains the
information you need. Look up System tables in BOL. Choose All Databases
as the subtopic. Scroll down to the section called "Tables in the MSDB
database" for more details.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> Hi All,
> Can anyone tell me if there is any system table/view/SP available where I
> can query to view the path of a database backup file when the last
> database
> backup is taken?
> For example I can find the backup information(like backup begin start
> date,
> backup finish date, etc) of a database using msdb.dbo.backupset. I am
> looking for something similar query where I can see the location, either
> to
> tape, device, or any local directory, of the backup.
> Thanks a lot,
> VM|||Thanks Sue! It worked.
VM
"Sue Hoegemeier" wrote:
> Take a look at the backupmediafamily table in msdb. The
> columns Physical_device_name and device_type tell you what
> device and path was used for the backup.
> -Sue
> On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
> <VM@.discussions.microsoft.com> wrote:
>
>|||Thanks for Information Geoff. I was looking for backupmediafamily table.
VM
"Geoff N. Hiten" wrote:
> There is a child table of backupset called backupfile that contains the
> information you need. Look up System tables in BOL. Choose All Databases
> as the subtopic. Scroll down to the section called "Tables in the MSDB
> database" for more details.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
>
>|||Sue was right with backupmediafamily. I should have looked at my backup
management code instead of writig from memory. Either way, the information
in BOL is very useful.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:5E526962-6D6A-4827-8EAE-FBA04E9EF8CD@.microsoft.com...[vbcol=seagreen]
> Thanks for Information Geoff. I was looking for backupmediafamily table.
> VM
> "Geoff N. Hiten" wrote:
>
Can anyone tell me if there is any system table/view/SP available where I
can query to view the path of a database backup file when the last database
backup is taken?
For example I can find the backup information(like backup begin start date,
backup finish date, etc) of a database using msdb.dbo.backupset. I am
looking for something similar query where I can see the location, either to
tape, device, or any local directory, of the backup.
Thanks a lot,
VMTake a look at the backupmediafamily table in msdb. The
columns Physical_device_name and device_type tell you what
device and path was used for the backup.
-Sue
On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Can anyone tell me if there is any system table/view/SP available where I
>can query to view the path of a database backup file when the last database
>backup is taken?
>For example I can find the backup information(like backup begin start date,
>backup finish date, etc) of a database using msdb.dbo.backupset. I am
>looking for something similar query where I can see the location, either to
>tape, device, or any local directory, of the backup.
>Thanks a lot,
>VM|||There is a child table of backupset called backupfile that contains the
information you need. Look up System tables in BOL. Choose All Databases
as the subtopic. Scroll down to the section called "Tables in the MSDB
database" for more details.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> Hi All,
> Can anyone tell me if there is any system table/view/SP available where I
> can query to view the path of a database backup file when the last
> database
> backup is taken?
> For example I can find the backup information(like backup begin start
> date,
> backup finish date, etc) of a database using msdb.dbo.backupset. I am
> looking for something similar query where I can see the location, either
> to
> tape, device, or any local directory, of the backup.
> Thanks a lot,
> VM|||Thanks Sue! It worked.
VM
"Sue Hoegemeier" wrote:
> Take a look at the backupmediafamily table in msdb. The
> columns Physical_device_name and device_type tell you what
> device and path was used for the backup.
> -Sue
> On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
> <VM@.discussions.microsoft.com> wrote:
>
>|||Thanks for Information Geoff. I was looking for backupmediafamily table.
VM
"Geoff N. Hiten" wrote:
> There is a child table of backupset called backupfile that contains the
> information you need. Look up System tables in BOL. Choose All Databases
> as the subtopic. Scroll down to the section called "Tables in the MSDB
> database" for more details.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
>
>|||Sue was right with backupmediafamily. I should have looked at my backup
management code instead of writig from memory. Either way, the information
in BOL is very useful.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:5E526962-6D6A-4827-8EAE-FBA04E9EF8CD@.microsoft.com...[vbcol=seagreen]
> Thanks for Information Geoff. I was looking for backupmediafamily table.
> VM
> "Geoff N. Hiten" wrote:
>
Path of the backup file
Hi All,
Can anyone tell me if there is any system table/view/SP available where I
can query to view the path of a database backup file when the last database
backup is taken?
For example I can find the backup information(like backup begin start date,
backup finish date, etc) of a database using msdb.dbo.backupset. I am
looking for something similar query where I can see the location, either to
tape, device, or any local directory, of the backup.
Thanks a lot,
VMTake a look at the backupmediafamily table in msdb. The
columns Physical_device_name and device_type tell you what
device and path was used for the backup.
-Sue
On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Can anyone tell me if there is any system table/view/SP available where I
>can query to view the path of a database backup file when the last database
>backup is taken?
>For example I can find the backup information(like backup begin start date,
>backup finish date, etc) of a database using msdb.dbo.backupset. I am
>looking for something similar query where I can see the location, either to
>tape, device, or any local directory, of the backup.
>Thanks a lot,
>VM|||There is a child table of backupset called backupfile that contains the
information you need. Look up System tables in BOL. Choose All Databases
as the subtopic. Scroll down to the section called "Tables in the MSDB
database" for more details.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> Hi All,
> Can anyone tell me if there is any system table/view/SP available where I
> can query to view the path of a database backup file when the last
> database
> backup is taken?
> For example I can find the backup information(like backup begin start
> date,
> backup finish date, etc) of a database using msdb.dbo.backupset. I am
> looking for something similar query where I can see the location, either
> to
> tape, device, or any local directory, of the backup.
> Thanks a lot,
> VM|||Thanks Sue! It worked.
VM
"Sue Hoegemeier" wrote:
> Take a look at the backupmediafamily table in msdb. The
> columns Physical_device_name and device_type tell you what
> device and path was used for the backup.
> -Sue
> On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Can anyone tell me if there is any system table/view/SP available where I
> >can query to view the path of a database backup file when the last database
> >backup is taken?
> >
> >For example I can find the backup information(like backup begin start date,
> >backup finish date, etc) of a database using msdb.dbo.backupset. I am
> >looking for something similar query where I can see the location, either to
> >tape, device, or any local directory, of the backup.
> >
> >Thanks a lot,
> >VM
>|||Thanks for Information Geoff. I was looking for backupmediafamily table.
VM
"Geoff N. Hiten" wrote:
> There is a child table of backupset called backupfile that contains the
> information you need. Look up System tables in BOL. Choose All Databases
> as the subtopic. Scroll down to the section called "Tables in the MSDB
> database" for more details.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> > Hi All,
> >
> > Can anyone tell me if there is any system table/view/SP available where I
> > can query to view the path of a database backup file when the last
> > database
> > backup is taken?
> >
> > For example I can find the backup information(like backup begin start
> > date,
> > backup finish date, etc) of a database using msdb.dbo.backupset. I am
> > looking for something similar query where I can see the location, either
> > to
> > tape, device, or any local directory, of the backup.
> >
> > Thanks a lot,
> > VM
>
>|||Sue was right with backupmediafamily. I should have looked at my backup
management code instead of writig from memory. Either way, the information
in BOL is very useful.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:5E526962-6D6A-4827-8EAE-FBA04E9EF8CD@.microsoft.com...
> Thanks for Information Geoff. I was looking for backupmediafamily table.
> VM
> "Geoff N. Hiten" wrote:
>> There is a child table of backupset called backupfile that contains the
>> information you need. Look up System tables in BOL. Choose All
>> Databases
>> as the subtopic. Scroll down to the section called "Tables in the MSDB
>> database" for more details.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
>> > Hi All,
>> >
>> > Can anyone tell me if there is any system table/view/SP available where
>> > I
>> > can query to view the path of a database backup file when the last
>> > database
>> > backup is taken?
>> >
>> > For example I can find the backup information(like backup begin start
>> > date,
>> > backup finish date, etc) of a database using msdb.dbo.backupset. I am
>> > looking for something similar query where I can see the location,
>> > either
>> > to
>> > tape, device, or any local directory, of the backup.
>> >
>> > Thanks a lot,
>> > VM
>>
Can anyone tell me if there is any system table/view/SP available where I
can query to view the path of a database backup file when the last database
backup is taken?
For example I can find the backup information(like backup begin start date,
backup finish date, etc) of a database using msdb.dbo.backupset. I am
looking for something similar query where I can see the location, either to
tape, device, or any local directory, of the backup.
Thanks a lot,
VMTake a look at the backupmediafamily table in msdb. The
columns Physical_device_name and device_type tell you what
device and path was used for the backup.
-Sue
On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Can anyone tell me if there is any system table/view/SP available where I
>can query to view the path of a database backup file when the last database
>backup is taken?
>For example I can find the backup information(like backup begin start date,
>backup finish date, etc) of a database using msdb.dbo.backupset. I am
>looking for something similar query where I can see the location, either to
>tape, device, or any local directory, of the backup.
>Thanks a lot,
>VM|||There is a child table of backupset called backupfile that contains the
information you need. Look up System tables in BOL. Choose All Databases
as the subtopic. Scroll down to the section called "Tables in the MSDB
database" for more details.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> Hi All,
> Can anyone tell me if there is any system table/view/SP available where I
> can query to view the path of a database backup file when the last
> database
> backup is taken?
> For example I can find the backup information(like backup begin start
> date,
> backup finish date, etc) of a database using msdb.dbo.backupset. I am
> looking for something similar query where I can see the location, either
> to
> tape, device, or any local directory, of the backup.
> Thanks a lot,
> VM|||Thanks Sue! It worked.
VM
"Sue Hoegemeier" wrote:
> Take a look at the backupmediafamily table in msdb. The
> columns Physical_device_name and device_type tell you what
> device and path was used for the backup.
> -Sue
> On Mon, 16 Jan 2006 11:38:02 -0800, "VM"
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Can anyone tell me if there is any system table/view/SP available where I
> >can query to view the path of a database backup file when the last database
> >backup is taken?
> >
> >For example I can find the backup information(like backup begin start date,
> >backup finish date, etc) of a database using msdb.dbo.backupset. I am
> >looking for something similar query where I can see the location, either to
> >tape, device, or any local directory, of the backup.
> >
> >Thanks a lot,
> >VM
>|||Thanks for Information Geoff. I was looking for backupmediafamily table.
VM
"Geoff N. Hiten" wrote:
> There is a child table of backupset called backupfile that contains the
> information you need. Look up System tables in BOL. Choose All Databases
> as the subtopic. Scroll down to the section called "Tables in the MSDB
> database" for more details.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
> > Hi All,
> >
> > Can anyone tell me if there is any system table/view/SP available where I
> > can query to view the path of a database backup file when the last
> > database
> > backup is taken?
> >
> > For example I can find the backup information(like backup begin start
> > date,
> > backup finish date, etc) of a database using msdb.dbo.backupset. I am
> > looking for something similar query where I can see the location, either
> > to
> > tape, device, or any local directory, of the backup.
> >
> > Thanks a lot,
> > VM
>
>|||Sue was right with backupmediafamily. I should have looked at my backup
management code instead of writig from memory. Either way, the information
in BOL is very useful.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"VM" <VM@.discussions.microsoft.com> wrote in message
news:5E526962-6D6A-4827-8EAE-FBA04E9EF8CD@.microsoft.com...
> Thanks for Information Geoff. I was looking for backupmediafamily table.
> VM
> "Geoff N. Hiten" wrote:
>> There is a child table of backupset called backupfile that contains the
>> information you need. Look up System tables in BOL. Choose All
>> Databases
>> as the subtopic. Scroll down to the section called "Tables in the MSDB
>> database" for more details.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:A0E40887-16A5-4128-8AEE-DE5955C79860@.microsoft.com...
>> > Hi All,
>> >
>> > Can anyone tell me if there is any system table/view/SP available where
>> > I
>> > can query to view the path of a database backup file when the last
>> > database
>> > backup is taken?
>> >
>> > For example I can find the backup information(like backup begin start
>> > date,
>> > backup finish date, etc) of a database using msdb.dbo.backupset. I am
>> > looking for something similar query where I can see the location,
>> > either
>> > to
>> > tape, device, or any local directory, of the backup.
>> >
>> > Thanks a lot,
>> > VM
>>
Friday, March 9, 2012
Password protected BAK Files
Hello All,
Can anyone help me? I would like to put a password on BAK files everytime my
backup jobs run. So that when I restore a db from one of these BAK files, I
need to provide the password.
Thanks in Advance,
Tuoc"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
If you are looking to secure your BAK files, consider using EFS (Encrypted
File System) for the folder that you dump your BAK files. Even if you could
make this work, file level passwords would not be of any value.
Steve|||SQL2000 only
BACKUP DATABASE pubs to DISK = 'c:\pubs.bak'
WITH PASSWORD = 'test'
If you try and restore this without a password, you get
RESTORE DATABASE pubs FROM DISK = 'c:\pubs.bak'
WITH REPLACE
Server: Msg 3279, Level 16, State 2, Line 1
Access is denied due to a password failure
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
To restore, you need the password e.g.
RESTORE DATABASE pubs FROM DISK = 'c:\pubs.bak'
WITH REPLACE,PASSWORD = 'test'
However, I've never really seen anyone use this. There's also the issue of
managing/generating/storing the passwords so they're not just hardcoded into
the jobs but using something like NEWID would probably do it but you would
have to store it with the backup filename somewhere so you could restore it
e.g.
declare @.p varchar(36) ; set @.p = NEWID()
declare @.file varchar(200) ; set @.file = '<generate filename>'
-- store password away somewhere secure with filename
BACKUP DATABASE pubs to DISK = @.file
WITH PASSWORD = @.p
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
You also posted this on .server where there are quite a few reponses. Please
do not post the same questions on multiple newsgroups independently, so you
will not have to follow multiple threads of response, and so other people
won't waste time answering a question that has already been answered.
Thanks!
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
I'm sorry about that.
Tuoc
Can anyone help me? I would like to put a password on BAK files everytime my
backup jobs run. So that when I restore a db from one of these BAK files, I
need to provide the password.
Thanks in Advance,
Tuoc"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
quote:
> Can anyone help me? I would like to put a password on BAK files everytime
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
quote:
>
If you are looking to secure your BAK files, consider using EFS (Encrypted
File System) for the folder that you dump your BAK files. Even if you could
make this work, file level passwords would not be of any value.
Steve|||SQL2000 only
BACKUP DATABASE pubs to DISK = 'c:\pubs.bak'
WITH PASSWORD = 'test'
If you try and restore this without a password, you get
RESTORE DATABASE pubs FROM DISK = 'c:\pubs.bak'
WITH REPLACE
Server: Msg 3279, Level 16, State 2, Line 1
Access is denied due to a password failure
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
To restore, you need the password e.g.
RESTORE DATABASE pubs FROM DISK = 'c:\pubs.bak'
WITH REPLACE,PASSWORD = 'test'
However, I've never really seen anyone use this. There's also the issue of
managing/generating/storing the passwords so they're not just hardcoded into
the jobs but using something like NEWID would probably do it but you would
have to store it with the backup filename somewhere so you could restore it
e.g.
declare @.p varchar(36) ; set @.p = NEWID()
declare @.file varchar(200) ; set @.file = '<generate filename>'
-- store password away somewhere secure with filename
BACKUP DATABASE pubs to DISK = @.file
WITH PASSWORD = @.p
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
quote:
> Hello All,
> Can anyone help me? I would like to put a password on BAK files everytime
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
quote:|||Tuoc
> Thanks in Advance,
> Tuoc
You also posted this on .server where there are quite a few reponses. Please
do not post the same questions on multiple newsgroups independently, so you
will not have to follow multiple threads of response, and so other people
won't waste time answering a question that has already been answered.
Thanks!
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Tuoc" <anonymous@.discussions.microsoft.com> wrote in message
news:D9549303-3521-4C75-ABFB-685820FC140D@.microsoft.com...
quote:
> Hello All,
> Can anyone help me? I would like to put a password on BAK files everytime
my backup jobs run. So that when I restore a db from one of these BAK files,
I need to provide the password.
quote:|||Kalen,
> Thanks in Advance,
> Tuoc
I'm sorry about that.
Tuoc
Subscribe to:
Posts (Atom)