Creating a Monthend Database

Before I moved all the Access Databases to SQL I was able to create a monthe
nd database for each database we had. It wasn't too time consuming as it wa
s a simple copy and paste each month. Now that everything is moved over to
SQL I had told the Acctg De
pt that I would prefer not to continue with the monthend companies as it is
more time consuming to administer. All they use the monthend copies for are
for reference if needed throughout the month. When I questioned how much t
hey actually refer back to
it, it is not very often. They were quite persistent and old habits are har
d to break so I need to find an efficient way of creating the monthend datab
ases and then copying them each month. Does anyone have any suggestions? Y
our input is great apprecia
ted!
Thanks
DebIf your month-end database is simply a snapshot of your operational database
at a specific point in time, you can copy the database to different database
and file names using backup/restore.
Hope this helps.
Dan Guzman
SQL Server MVP
"Deb" <anonymous@.discussions.microsoft.com> wrote in message
news:982F6016-7AE2-499D-9634-9BE97BA4223B@.microsoft.com...
> Before I moved all the Access Databases to SQL I was able to create a
monthend database for each database we had. It wasn't too time consuming as
it was a simple copy and paste each month. Now that everything is moved
over to SQL I had told the Acctg Dept that I would prefer not to continue
with the monthend companies as it is more time consuming to administer. All
they use the monthend copies for are for reference if needed throughout the
month. When I questioned how much they actually refer back to it, it is not
very often. They were quite persistent and old habits are hard to break so
I need to find an efficient way of creating the monthend databases and then
copying them each month. Does anyone have any suggestions? Your input is
great appreciated!
> Thanks
> Deb