| Author |
Topic |
|
bkpgamble
Starting Member
30 Posts |
 Posted - 2006-10-11 : 04:13:46
|
| I want to check if a database has had changes since last backupis there anny flag og timestamp that would indicate this ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-11 : 04:19:50
|
| Changes for what?Table layout changes? Data changes?Peter LarssonHelsingborg, Sweden |
 |
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 04:32:43
|
| Anny change made to a database structure like table or data I want to determine if a backup is needed if I already have one from a later data and no changes have been madelike on model DB not much happends thereI'am running 2005 enterprise btw |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-11 : 05:12:40
|
| I guess you should look for tool called as DbCompare search on google and u will get some links.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 05:21:06
|
| I want to know if a backup is needed or if my full backup from last week is still up to datethere must be somekidda SP or some other way to se if changes have been made ? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-11 : 05:30:53
|
| Why do you want to know this?If the purpose is only for taking backup if there are some changes, you can go for Differential Backup.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 06:08:23
|
| Yes I intend to use Differential Backup BUT I also want a weekly full backup I dont want to take full backups if there has been no changes. I need this for my flow so that it can check for changes and from this determine if a new full backup is needed or not |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-11 : 06:12:23
|
| Full backup is really useful to take once a week, at least.I haven't done any restore for differential backup yet, but don't you need every backup since last full backup for this?Peter LarssonHelsingborg, Sweden |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 06:22:32
|
| how can you say full backup is usefull to take once a week if there has been no changes in that databaseLike a database were I have only static tables its size is 150gb. I dont want to have 10 full backups in my flow wenn they all contain the same.But this is really not what I'am asking...All I want to know is if there is a way to se if a database has changed since last backup |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-11 : 06:27:40
|
| Even if there are no changes in either table layouts and the data in the tables, there can still be changes to the server with new users, new data types, new jobs, new maintenance plans and so on...Peter LarssonHelsingborg, Sweden |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 06:38:29
|
| Note takenBut I will still ask again....is there a way to se if a database has changed since last backup ? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-11 : 07:59:57
|
| No in-built tool to do this...Use some third party tool (as one suggested by Chirag)Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 08:17:24
|
| Ok thanks |
|
|
|
bkpgamble
Starting Member
30 Posts |
Posted - 2006-10-11 : 08:41:14
|
| Can it be true that TRUNCATE TABLE cant be granted explicit to a user connecting to your DBthis this user run it thru a SP so theCREATE PROCEDURE dbo.usp_TruncateMyTableWITH EXECUTE AS SELFAS TRUNCATE TABLE MyDB..MyTable;is not an optionand I dont want to give it db_ddladmin, db_owner or sysadmin rightsI'am looking at granting this user specific rights to truncateI look under DB premissions but dont know wich DB options should be enabled for it to run ? |
|
|
|
|
Is there anny way