Process Control Systems SIMATIC PCS 7
SQL Server Database Backup for Central Archive Server
Thread Starter: jenie Started: 8/10/2007 7:58 AM Replies: 4
8/10/2007, 7:58 AM
|
Joined 10/3/2006
Last visit: 5/19/2013
Posts: 38
Rating:
![Rated: no ratings [0 out of 5 / rated 0 time(s)].](/forum/Skins/images/Star0.user.gif) (0)
|
![Rated: no ratings [0 out of 5 / rated 0 time(s)].](/forum/Skins/images/Star0.post.gif) (0)
|
Hi,
I would like to know which databases I should include when creating a backup of the Central Archive Server.
I created a database maintenance plan of creating backups of all the databases every 12nn, twice a week. Most of the time, back-up is successful, but sometimes it is not. I have included a log file of the database maintenance plan from SQL as reference. According to the log file, it seems that I should not include all the databases. Do you have any technical documents regarding this?
Regards,
Jenie
=== Edited by jenie @ 10.08.2007 08:00 [GMT ] ===
|
|
|
|
|
8/10/2007, 5:28 PM
|
Joined 8/10/2006
Last visit: 5/20/2013
Posts: 294
Rating:
![Rated: Excellent [4.07 out of 5 / rated 27 time(s)].](/forum/Skins/images/Star4Half.user.gif) (27)
|
|
(0)
|
Jenie,
Could you please post your SQLMaint command line?
My next question would be, has anything changed on the server - configurations, modification of the project, etc.?
Looking at the reports, it appears the system is trying to back up a database that was from a previous OS download, or some similar type of event where something changed in the system, and that set of DB's had been deleted.
|
|
|
|
8/16/2007, 8:13 AM
|
Joined 10/3/2006
Last visit: 5/19/2013
Posts: 38
Rating:
(0)
|
|
(0)
|
Hi Unimogman,
Thanks for the reply.
I will send you the script on my next post, I am still waiting for it on my email.
Does this mean that everytime I make a compilation of the PCS7 project, I have to reconfigure the Database Maintenance plan in SQL Server? Recently we have added some tags to the PCS7 System but I havent checked if there was a change in the databases of the Central Archive Server and I just made the maintenance plan 1 time only and I included all databases in the backup script. There was a check mark to select all databases during the configuration and I checked it because I dont know which specific databases are necessary for the backup.
Regards,
Jenie
|
|
|
|
8/18/2007, 8:56 AM
|
Joined 8/10/2006
Last visit: 5/20/2013
Posts: 294
Rating:
(27)
|
|
(0)
|
My understanding is the databases configured are stored in SQL Server, and automatically managed.
|
|
|
|
8/25/2007, 12:28 AM
|
Joined 8/10/2006
Last visit: 5/20/2013
Posts: 294
Rating:
(27)
|
|
(0)
|
Did you change your computer name?
I changed my ES computer name a few months ago, and behold, the old instance of the database is still listed (actually the exact same database, but navigation to it is different -- i.e. newPCname\WinCC). Just happened to stumble across that yesterday.
So if I had tried to backup that database, it would no longer exist, and of course fail.
HTH,
Jim
=== Edited by UnimogMan @ 25.08.2007 00:29 [GMT ] ===
|
|
|
|
|
Actions
Print