Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

backing up the project

Created by: stplanken at: 11/23/2006 5:39 PM (15 Replies)

Rating (1)

Thanks 0

Result pages:: |; 1 | 2; |

16 Entries

Entries per page: 10 | all

11/23/2006 5:39 PM	Rate (0)
stplanken Silver Member Joined: 3/4/2006 Last visit: 11/28/2024 Posts: 73 Rating: (3)	Salma, When backing up the project, the SQL service is is always preventing me from copying all the data files, although the project was obviously stopped and it seems the database was properly detached. I automated this with a script: [code]@echo off if /i "%COMPUTERNAME%" equ "srvwincc" goto STARTBAK echo ------------------------------------------------- echo Execute this from srvwincc to ensure all echo permissions are copied properly. echo ------------------------------------------------- goto END :STARTBAK net stop mssql$wincc robocopy "C:\UFO_WINCC_PROJ\UFO_WINCC_RUN" "D:\UFO_WINCC_PROJ\UFO_WINCC_RUN" /E /SEC /R:1 /W:1 net start mssql$wincc goto END :END[/code]
	Last edited by: Blue Moderator at: 11/23/2006 8:19 PM Splitted thread and renamed it
Suggestion To thank Quote Answer

11/23/2006 5:46 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Hi stplanken Firstly I have asked the moderator to split this into a new thread [;)] Now, as you are stopping MSSQLServer surelyit is not possible that it can be preventing the copy !?! Unless of course I have misunderstood your question [:blush:] Can you provide more information on this one ? Such as : - is WinCC closed completely or just deactivated; - can you manually copy the project directory using Windows Explorer; - have you tried running the C:\Program Files\Siemens\WinCC\bin\Reset_WinCC.vbs script file to be absolutely sure that WinCC is stopped and all databases detached. Salma We dance in a circle and suppose,while the secret sits in the middle and knows

Suggestion To thank Quote Answer

11/24/2006 12:11 AM	Rate (0)
stplanken Silver Member Joined: 3/4/2006 Last visit: 11/28/2024 Posts: 73 Rating: (3)	(Apologies, I did not intend to hijack this thread.) The project was completely closed, I just received an error when copying the database files. Since I did not get the error with the mssql$wincc service stopped I now assume -- after having read your initial remark about this in the other thread -- that the database did not detach. Since this plant shuts down this Sunday for maintenance and the servers need to be shut down I will pay extra attention to see if the database actually detaches on the server when I stop/close the project and exit WinCC EXplorer.

Suggestion To thank Quote Answer

11/27/2006 9:23 PM	Rate (0)
stplanken Silver Member Joined: 3/4/2006 Last visit: 11/28/2024 Posts: 73 Rating: (3)	Salma, So yesterday I backed up the project on the server again. All eight client machines were logged off, two were not shut down yet. The database files (*.mdf) must still have been locked, a simple copy from Windows resulted in an access violation error. Stephan

Suggestion To thank Quote Answer

11/28/2006 9:31 AM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, If you go to star" -> Programs -> microsoft sql server -> enterprise mangaer And then stop the service. You should be able to back it up. A lot of times it (the client or server) keeps a connection to the database. You won't be able to back it up then. Report your findings. with regards, Ikkezelf
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

11/29/2006 7:38 AM	Rate (0)
stplanken Silver Member Joined: 3/4/2006 Last visit: 11/28/2024 Posts: 73 Rating: (3)	Thanks for your reply. Stopping the service is how I have always done it -- see the script I posted earlier. But after having read what Salma wrote I understood that wouldn't be necessary so I thought something was wrong. But you are right, it seems that even with no client activity the database is still in use.

Suggestion To thank Quote Answer

11/29/2006 2:29 PM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	yes it is.
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

11/29/2006 4:34 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Yep something is wrong but I'm not sure what. Just found an FAQ mentioning this problem is your WinCC project is called WinCC. Is this relevant to you ? Salma We dance in a circle and suppose,while the secret sits in the middle and knows

Suggestion To thank Quote Answer

11/29/2006 5:02 PM	Rate (0)
stplanken Silver Member Joined: 3/4/2006 Last visit: 11/28/2024 Posts: 73 Rating: (3)	No, the project name is the company name.

Suggestion To thank Quote Answer

11/29/2006 5:19 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Hmmm, how are you shutting down WinCC ? If you are shutting it down manually from WinCC Explorer then it comes up with a dialog box with two options - you must select "Close project and Exit Explorer" and not "Exit Explorer". Is this what you are doing ? Salma We dance in a circle and suppose,while the secret sits in the middle and knows

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on