Sunday, February 26, 2012

For Restore Operation

Hello Experts,
How can I find using T-SQL, if my database has changed
since tha last backup?
Thanks in advance!Hi
Just before Backup the database insert into table (File_Growth)
SELECT * FROM SYSFILES and compare it with last backup values to look how
big your database is.
"Konstantinos Michas" <anonymous@.discussions.microsoft.com> wrote in message
news:2114101c459d3$0085b270$a001280a@.phx
.gbl...
> Hello Experts,
> How can I find using T-SQL, if my database has changed
> since tha last backup?
> Thanks in advance!|||Ok, thank you Uri.

>--Original Message--
>Hi
>Just before Backup the database insert into table
(File_Growth)
>SELECT * FROM SYSFILES and compare it with last backup
values to look how
>big your database is.
>"Konstantinos Michas"
<anonymous@.discussions.microsoft.com> wrote in message
> news:2114101c459d3$0085b270$a001280a@.phx
.gbl...
>
>.
>

No comments:

Post a Comment