我正试图指出,2005年,Skker DBAs正在如何进行后备和核查。 我利用Idera免费储存的代用品(不再可以下载)进行备份和核实,并大约压抑65%。 如果有其他自由选择?
如果不确定这是Idera的描述,但你可以把(native)卡片封到一个临时地点,然后打电话给PKZip或7zip或一些指挥线压缩软件,以压缩永久储存地点。
请注意,这些冲积设施中的大多数成本很高。
See the discussion in the comments of this post: https://blog.stackoverflow.com/2009/02/our-backup-strategy-inexpensive-nas/
(Edit: Or Just up to GL2008 R2, which support home reuppression.)
你们使用的Idera是一种三维工具,其工具可以是备份/备用和备份;你可以监测服务器和邮局;数据库。
As you asked the question- am trying to figure out how SQL Server DBAs are doing their backups and verify in 2005. I use the Idera s free stored procs (which is no longer available to download btw) to backup and verify and have gotten around 65% compression. If there any other free alternative?
SQL server has it s own native tool where you can set up your backup of databases to go disk, usually with the SSIS packages by using Maitenace plan (or)T-sql(where you can configure Full,differntial and log backup also)(where after backup finish you can check the verify integrity of the backup) but if the database grows more and more then you may need to ensre about the capcity as this goes to disk(here you need cut the backup stragegy for big database say 1TB bcz usually for Big database taking full daily causes lot of I/O then you have to decide weekly full backup along with the other days differntial backup in place) & you should do the cleanup also for howmany days you want(in the same maintenace plan only it exists).
见http://bradmcgehee.com/201001/13/how-to-use-sql-backup-inside-a-maintenance-plan/“rel=“nofollow”http://bradmcgehee.com 201001/13/how-to-use-sql-backup-in-a-maintenance-plan/。
但是,支持/逮捕完全取决于你如何通过了解商业风险和计划来管理你;与他们交流。
在2008年克勒服务器中,你像Idera sql安全做些什么一样,支持压缩。
但是,退学通常取决于他们是否从土著工具,还是从其他第3部分,如Commvault、Idera、TDP(带磁带)等实施。
Backup- http://msdn.microsoft.com/en-us/library/ms186865.aspx
免费(好)Kall DBA工具难以找到=/。
您是否考虑了Windows Backup?
这肯定不是最好的事,它占用了许多空间,但它是免费的,它确实支持你的数据,而且你已经安装了这些数据。
On a windows mobile unit, the software I m working on relies on a sdf file as it s database. The platform that the software is targeted towards is "less than optimal" and hard resets every once and a ...
I have a mysqldump file of multiple databases (5). One of the database takes a very long time to load, is there a way to either split the mysqldump file by database, or just tell mysql to load only ...
Within Cognos 7.4 security.. one would create an LAE file to export all their users... directions here... http://www.cognos-install.co.uk/articles/backups/access_manager_export_to_lae.asp Now you ...
We have a web application that creates a dynamic PHP page with all the MySQL stored details a user has entered via a number a forms. So far so good, but we want this information stored some how to be ...
I have one stored procedure to backup the database. It will backup metadata as well as data. Is there any option to back up the database with out data. ie, back up only the schema (Empty tables). I ...
We want to have our test servers databases updated from our production server databases on a nightly basis to ensure we re developing on the most recent data. We, however, want to ensure that any fn, ...
I m on a team using Git right now, and we have a pretty good workflow. We have a central repository with two branches, dev and master. We create local branches to work on individual tasks. We merge ...
When i try to get a dump of a mysql database, the dump stops when a row in it is updated. How can i prevent that? I already tried following options with no result: -f (forces continu even when error)...
