I have inherited a Windows 2000 (Pro SP4) PC running some restaurant software with SQL Server 2000. The owner doesn't want to spend a lot of $$$ for SQL backup software, and I am no SQL genius. Is there some handy script I can plug in somewhere which will make a simple full copy of the DB or something daily?
I see some apparently useful info at http://www.akadia.com/services/sqlsrv_programming.html#Backup%20a%20Database
but I'm not sure where this goes.
And btw where is the Enterprise Manager executable? I can't seem to find it.