Damage to tables is very rare unless a user does something like deleting records your system will be very stable. And SQL server has a number of options for backup. I usually go with a full backup each week and a differential backup nightly. I also back up the log as often as deemed necessary. If the data is being entered or changed frequently I do a log backup every 5 minutes. That way, if a restore is necessary I only lose 5 minutes of work.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :Bill-The only thing I worried about is that if the tables in SQL Server are damaged, will I be able to get it repaired with help of some utilities, or get back to previous backups. If this is not a problem, SQL Sever is definitely the best choice.Best Regards,Kevin发自我的小米手机在 "'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月25日 上午11:45写道：Kevin – Oh, no you don't! You still have to weigh what is best for your situation. Don't make me the deciding vote!
But I'm glad you feel confident to proceed. I'm sure you will find the right path of success.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, November 24, 2015 4:56 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re:[MS_AccessPros] Re: sql server
Bill-
With your instruction, I will unhesitatingly choose to learn SQL Sever. Thanks you so much.
Best Regards,
Kevin
发自我的小米手机
在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月25日 上午12:05写道：
I hit Send way too soon. I meant to add this:
I've been working with SQL Server databases as back ends to my Access applications and the more I use them the more I love them. Security is top-notch, backups are scheduled and done without baby-sitting, And as long as you prepare for things I mentioned in my article you will find it very easy to use SQL tables and views.
The biggest advantage is the much more powerful engine.If handled properly batch jobs are terrifically faster than in Access. Those complex queries that take forever to return results are instantaneous in SQL.
I advise you to learn SQL code if you don't already know it. It will help you when it comes time to build views and stored procedures. The SQL Server Management Studio has some parts that are similar to Access such as building tables and queries in design view, but after awhile you will probably feel more comfortable just writing the SQL code to do that stuff.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :Dear All,
I am new to sql server, but if I manage to export database backend from access to sql server, and learnt some basic backup skills, do you think it is possible to work in this context without problem? Any suggestions? Thanks in advance.
Best Regards,
Kevin
发自我的小米手机
Posted by: zhaoliqingoffice <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar