quaium
-
Posts
108 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by quaium
-
Its a Powershell script (.ps1) it won't work as a batch file.
-
Yes, that's correct.
-
All the definations are defined at the start of the script... # Common SIMS/FMS Backup Variables. $BackupPath = "D:\Backups" $SAPassword = "PASSWORD" $SIMSDBServer = "SERVERSIMS\SIMS" $SIMSDBAttach = "D:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\DbAttach.exe" $FMSDBServer = "SERVERSIMS\FMS" $FMSDBAttach = "D:\Program Files\Microsoft SQL Server\MSSQL11.FMS2012\MSSQL\Binn\FMSSQL\DbAttach.exe" So anywhere $SIMSDBServer is used it will equal what you have defined. You're $SIMSDBServer or $FMSDBServer would vm-data-01\sql2012, the sql2012 is the instance name and you would need to find that out.
-
Q1. DBAttach can backup the master but you're right only via the GUI, or if I am correct if no destination is provided in the script. For example, if "$SIMSDBAttach /BACKUP /AUTO /SERVER=$SIMSDBServer /DATABASE=SIMS /USER=sa /PASSWORD=$SAPassword /PATH=$BackupPath\SIMS.BAK" is used you'd get a SIMS.bak file in the destination provided. However, if you used "$SIMSDBAttach /BACKUP /AUTO /SERVER=$SIMSDBServer /DATABASE=SIMS /USER=sa /PASSWORD=$SAPassword" you would get a backup of the master, msdb and the sims/fms database in the backup folder of your SQL installation. Q2. I'm not sure about this but would be interesting to find out. Q3. The .sims.db_p_transfer_login part stays the same for both, you just need to add the database name to the start of it, for example, sims.sims.db_p_transfer_login or fms.sims.db_p_transfer_login Q4. I'm not sure about this too, I just used the script provided on here and modified it a little.
-
Tried the script last night and it worked fine. Managed to get the backups on to the test laptop and the FMS database restored with logins intact. Also an important note to anyone trying this... get the latest installation files from Capita! I spent days using an old DBAttach which was throwing out errors because I had copied over files from our live SIMS server. Thank you for the help and advice everyone.
-
Great, makes no sense to me but thanks. One final question... the SIMS and FMS database is also backed up using Backup Exec, running this routine before hand shouldn't have any effect on that should it?
-
Oh please don't mate! New to all this and it's like walking on egg shells! "sims is the schema" - is that by default and would it be the same for both databases even though they are on different SQL instances?
-
So I've managed to get together a script from the links provided. Could someone please check it over to see if everything is OK with it? # Common SIMS/FMS Backup Variables. $BackupPath = "D:\Backups" $SAPassword = "PASSWORD" $SIMSDBServer = "SERVERSIMS\SIMS" $SIMSDBAttach = "D:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\DbAttach.exe" $FMSDBServer = "SERVERSIMS\FMS" $FMSDBAttach = "D:\Program Files\Microsoft SQL Server\MSSQL11.FMS2012\MSSQL\Binn\FMSSQL\DbAttach.exe" # Backup SQL databases and copy to backup share. Write-Host "Perform Backup of SQL databases and copy to backup..." Import-Module SQLPS -DisableNameChecking Invoke-Sqlcmd -ServerInstance $SIMSDBServer -Username "sa" -Password $SAPassword -Query "exec sims.sims.db_p_transfer_login" Start-Sleep -s 30 Invoke-Sqlcmd -ServerInstance $FMSDBServer -Username "sa" -Password $SAPassword -Query "exec fmsacad.sims.db_p_transfer_login" Start-Sleep -s 30 $SIMSDBAttach /BACKUP /AUTO /SERVER=$SIMSDBServer /DATABASE=SIMS /USER=sa /PASSWORD=$SAPassword /PATH=$BackupPath\SIMS.BAK | Out-Host $FMSDBAttach /BACKUP /AUTO /SERVER=$FMSDBServer /DATABASE=FMSAcad /USER=sa /PASSWORD=$SAPassword /PATH=$BackupPath\FMS.BAK | Out-Host Two things, for the FMS sims.db_p_transfer_login is it correct that I have put in the database name at the beginning fmsacad.sims.db_p_transfer_login? And lastly, is it OK and safe to run the command sims.db_p_transfer_login, I'm not going to arrive tomorrow morning to find that users can't log in to SIMS or FMS or anything like that am I?
-
This works well but hides all the users from the directory if no groups are added, it's a shame you can't add users individually. But hey, I guess showing nothing is better. I will also try out some of the other methods, thanks everyone!
-
Hiding the Group via this method would hide it from the entire organisation, am I right in saying that? If so, that's not what we want, we still want staff to see the Group.
-
We would like to give students access to Gmail, however, some staff are worried that Students will send emails to the distribution groups (i.e. All_Teachers, All_Staff), is there a way of hiding these email groups so that it will not appear in the students Global Directory but will still appear for everyone else?
-
Yes, I've started again so will try and keep the environments as equal as possible. How do I use that stored procedure? Do I use it on the test laptop after restoring the database or do I use it during the backup procedure on the live server? If that's the case, how wound I run the backup of SIMS and FMS? Step by step instructions would be great.
-
Now that's interesting, thank you. Does anyone have a script that they use for SIMS and FMS backups that incorporates that script? My script has the following... "D:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Binn\DbAttach.exe" /BACKUP /SERVER="\" /USER="sa" /PASSWORD="password" /DATABASE="sims" /AUTO /PATH="d:\SIMSBackup\sims.bak" "D:\Program Files\Microsoft SQL Server\MSSQL10.\MSSQL\Binn\DbAttach.exe" /BACKUP /SERVER="\" /USER="sa" /PASSWORD="password" /DATABASE="fms" /AUTO /PATH="d:\SIMSBackup\fms.bak"
-
I tried that and it threw up an error when trying to restore the master database. I am rebuilding the laptop to see if using SQL Server 2012 makes any difference. I was using SQL Server 2017.
-
This is driving me crazy... I've created a backup using knowledgebase article KB400958 and I am still inable to log in to FMS on the laptop. Keeps getting the error about invalid login! What am I doing wrong here?
-
Sois this SQL procedure run before the backup is taken or after? The standalone laptop I have where I restored the backup taken from within FMS (Tools | FMS Transactions Backup) has users present in the FMS database from what I can see in SQL Management Studio but they can't log in,
-
What does this command do?
-
Does that script use the backup database option on DBAttach? I've not performed the backup I'm having issues with via DBAttach, it's the backup performed with FMS that causing the issues with user logins.
-
So I'm guessing that will means doing the backup via DBAttach? Not through FMS? The backup I have was done though FMS.
-
Ahhh... OK I found it in C:\Program Files\Microsoft SQL Server\MSSQL11.FMSDB\MSSQL\Binn\FMSSQL. Thanks. So to my other point, if I manually run DBAttach and do the Backup a Database thing from there, is this a valid backup for FMS and would restoring FMS mean restoring both the FMS database and the Master database for the user logins to stay intact?
-
Anyone got any ideas regarding this issue?
-
I carried out a backup of FMS via Tools | FMS Transactions Backup. I have restored this backup to a standalone laptop but it's not allowing me to log in to FMS. Can anyone tell me why this is happening? I've read that it could be because logins are stored in the Master database. I've also read that you need to use the FMS version of dbattach, but for some reason this isn't available on our SIMS server or the laptop I have set up. The path I am looking at is C:\Program Files\Microsoft SQL Server\MSSQL14.FMSDB\MSSQL\Binn and there's no sign of DBAttach. Final question, if I manually run DBAttach, whichever version, and do the Backup a Database thing from there, is this a valid backup for both SIMS and FMS and would restoring FMS mean restoring both the FMS database and the Master database for the user logins?
-
So, for some reason someone has put down next Friday as staff training on the school diary. As a result, the day isn't appearing on cover and there are no registers appaearing for staff on that day. Now, is the only way to remove this entry via Routines > School > Edit Academic Year or is there another way?
-
Thank you very much! That worked a treat.
-
Just noticed that our G Suite language was set to English (US), I have changed this to English (UK) now but this only changes it for new users. Is there a a way to change it on mass for existing users or is it a manual process?
