GP 9.0 backup ?

[ehojr]

We run a backup of our prepared payroll each week. This is right before we run checks in case we ned to re-run etc .. This process is done through sql currently via I/T support. IS it possible to have the payroll admin run this back up without i/T support?

 

[jymm]

What version of SQL?

In my opinion - this is more of a SQL question than a GP question, BUT - you can schedule SQL backups to occur on a set basis (let's say payroll is every other Thursday - you can run it at 6am every other thursday).

Without giving away some of the 'big' utilities for SQL it would take a small amount of effort to 'trigger' this if you wanted Payroll to be in control instead of it being on a scheduled basis.

When we were on SQL 7 I wrote a small ASP intranet screen that all it did was allow the user to push a button which would insert a record into a table (ask 'are you sure' before inserting of course). On insert this table had a t-sql trigger that would backup another database. I am pretty sure that you should be able to do similar with SQL 2k & 2005, but I have done away with that functionality since we can schedule the backups more often.

This help or you need more info?

 

[ehojr]

I was thinking triggers. we are on sql2005.. sounds good

 

[jymm]

sql2005 would be cake to do this.

have them search google on t-sql backup --- there are only about a million entries (like for everything else) and that should get them started. When I did my first thing like this I backed up a test DB, made some changes to the test DB - then did the restore - just because I am a firm believer that you do not do a back-up unless you plan on using it.

if you need more help holler - this bit of an idea should get them going ... although with 2005 if you are in the backup screen there is a button at the top that says 'script' - hit that and you get the command with your settings

BACKUP DATABASE [NorthWind] TO  DISK = N'E:\SQLData\MSSQL\BACKUP\NorthWind.bak' WITH NOFORMAT, NOINIT,  NAME = N'NorthWind-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

and that could be the 'simple' start for the t-sql - just a thought

 

[Dukester0122]

Another alternative is SQL Web Data Administration. I've given some users this tool then restricted there access to certain tables.

This is a free-tool for web access to the sql database just like a Query Analyzer.

 

[klewis10367]

Just use the interface within Great Plains. Go to file>Backup>, I believe you might need to be the sa or have a user that has sa rights.

 

[ehojr]

good advice form all.. I was wondering if this could not be done from the great plains interface.. I thought it was removed in version 9.0 I will check

 

[jymm]

and I thought that SQL Web Data Administration was only on 2000 and did not make the trip for 2005 - so this gives me something to look at too

 

[Dukester0122]

i'm not sure about that either as our production is still running on 2000 but test servers on 2005.

i'll check as well.