Monday, March 26, 2012

info about file or filegroup last change date?

Hi, all:
Is there any way we can use to find the time when the last change happened
to the file or filegroup?
Thanks in advanceThere is nothing built in to SQL Server that tracks changes to files, but
you can build, or buy, a solution that might fit your needs. What
specifically are you wanting to track?
"SQLNewbie" <SQLNewbie@.hotmail.com> wrote in message
news:eKpcK$5KEHA.240@.TK2MSFTNGP10.phx.gbl...
> Hi, all:
> Is there any way we can use to find the time when the last change happened
> to the file or filegroup?
> Thanks in advance
>|||I just want to make sure if the file or filegroup is not changed since I
last backed up the file, if it's not, I don't need to recover it if there is
a problem with database. Instead, I will recover other file(s) or
filegroup(s).
Thanks
"Don Peterson" <no1@.nunya.com> wrote in message
news:#lENwQ7KEHA.2716@.tk2msftngp13.phx.gbl...
> There is nothing built in to SQL Server that tracks changes to files, but
> you can build, or buy, a solution that might fit your needs. What
> specifically are you wanting to track?
> "SQLNewbie" <SQLNewbie@.hotmail.com> wrote in message
> news:eKpcK$5KEHA.240@.TK2MSFTNGP10.phx.gbl...
> > Hi, all:
> >
> > Is there any way we can use to find the time when the last change
happened
> > to the file or filegroup?
> >
> > Thanks in advance
> >
> >
>

No comments:

Post a Comment