microosoft
Active Newcomer
- Joined
- Aug 23, 2009
- Messages
- 8
- Reaction score
- 0
- Points
- 0
Hello all, thanks for reading this post.
I have a server which has Microsoft SQl Server and TSM TDPSql installed on it. i have around 50 SQL server databases on it with active usage. I run a full backup every month and differential backups every day.
But when a new SQL database is created, its backup fails because 'its full backup does not exist'. So I would like to make a little change to my sqldiff schedule script. Right now all it says is
%sql_dir%\tdpsqlc backup master full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqldiff.log >> %sql_dir%\sqldiffsched.log
%sql_dir%\tdpsqlc backup * diff
I would like to add a little script here that would take a full backups of the databases created that particular day along with full backup of master. And then, run the differential.
Something like select * from sys.databases where create date is 'today'. Can anyone help?
Thanks,
Ben
I have a server which has Microsoft SQl Server and TSM TDPSql installed on it. i have around 50 SQL server databases on it with active usage. I run a full backup every month and differential backups every day.
But when a new SQL database is created, its backup fails because 'its full backup does not exist'. So I would like to make a little change to my sqldiff schedule script. Right now all it says is
%sql_dir%\tdpsqlc backup master full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqldiff.log >> %sql_dir%\sqldiffsched.log
%sql_dir%\tdpsqlc backup * diff
I would like to add a little script here that would take a full backups of the databases created that particular day along with full backup of master. And then, run the differential.
Something like select * from sys.databases where create date is 'today'. Can anyone help?
Thanks,
Ben