Hi,
I am trying to schedule a job that will backup a table in my database, based on the name which has TABLENAME_mm_yyy that is 3 months old, then delete the table. Basically it is for archiving purposes, with the backup to be held on NT backup for another 12 months, just in case. Can anyone give me sugestions on how to do this - maybe alternatives?
Each monthly table has approx 4 million rows, that are rarely looked at. With other databases competing for space/resources, the thought was to remove these old tables monthly, with the ability to 'restore' them easily if/when required.
Any help or suggestions would be very much appreciated.
Hi, I am trying to do an automatic backup of my database and for some reason it does not do it. I have it set to backup daily at 4:00 pm. Please let me know if you know why it is not backing up on it's own. The Server manager is on always and a manual backup is not a problem for me, only the automatic. Thanks very much.
I am running a SQL Server 2000 installation with several databases. Eachdatabase and log is backed-up using a maintenance plan.The scheduled maintance plan for the latest database does not run, butdisplays no error. There is no entry in the job history. The same thinghappens when I try to run the individual jobs from Enterprise Manager.I've checked the database recovery model (full), the location of the backupfiles (same as the other databases), and just about everything else I canthink of. The scheduled maintenance plan for every other database runs asit should.What am I missing?ThanksIain
I have scheduled full backup daily at morning 6:00. It was running fine till yesterday. Suddenly today morning it failed giving following error....
I have executed maintenance plan manually and again it gave same error....
10/19/2007 11:03:10,FullDBBackup.Subplan_1,Error,1,*****,FullDBBackup.Subplan_1,Subplan_1,,Executed as user: ****SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:03:10 AM Error: 2007-10-19 11:03:10.98 Code: 0xC0010018 Source: Back Up Database (Full) Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2007-10-19 11:03:11.25 Code: 0xC00291EC Source: {C7FB73D1-ADF1-42C0-B3D5-9F8014CC206B} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2007-10-19 11:03:11.25 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DT... The package execution fa... The step failed.,00:00:01,0,0,,,,0
Pls help me as daily backups are very crucial to me...
I have a job scheduled that imports a table from a Oracle database. The job runs at 3am and reports success. But for some reason when i query the table to see how many records there are, I see the same row count as the day before (it should increase everyday- student enrollment). When i execute the package manually, the table updates fine.
I'm getting this message on my third automated backup of the transaction logs of the day. Both databases are in full recovery mode, both successfully backed up at 01.00. The transaction logs backed up perfectly happily at 01:30 and 05:30, but failed at 09:30.
The only difference between 05:30 and 09:30's backups is that the log files were shrunk at 08:15 (the databases in question are the ones that sit under ILM2007, and keeping the log files small keeps the system running better).
Is it possible that shrinking the log files causes the database to think that there hasn't been a full database backup?
How to export a specific table ? Export feature is allowing to export the whole database but not table. But i need to take the backup of a specific table to import on a remote server.
Hi, I have a giant DB that I want to backup. One of it's table is taking a lot of space, and I don't need it in the backup, so I am searching for a way to backup everything but that table in particular.
Does any of you know of a way? Thanks!
BTW, it's a Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
I have a large table that I need to play with a devise a solution. I want to make a back up copy of it so that if I crash it I can easily restore. What is the best way to backup/restore a single table?
hihow can i create a bak file of single table .And one more doubt ,whether its restorationprocess will be same as its for usual backup(ie full,transactinalbackup).ThanksTV
How can I restore just one table from the full backup? It was very easy with 6.5 but I am not sure whether it's possible with 7.0 and if it is possible, how to do it.
What is the best way (short of backing up the entire DB) to make a copy of a Table so that It can be easily restored. We have a table that we want to make some serious changes to, but I want to make sure I can restore if if I need to (if the changes don't work)
Hello i want to ask about the huge table(table with many tera records) backup time cost , any one can help me please in determining the time cost nearly
Anybody know how to backup a table with particular range.Ex one column contains date..I need to backup only data belong from date to date.is is possible via programming in C?if yes give example ( don`t tell backup SQL command)RLN
How to build a TRIGGER that copies, all the time, the data from the table onwhich the transaction occurs to the historical table?thanksFernand---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.659 / Virus Database: 423 - Release Date: 2004-04-15
Hi Is there a way to restore only one table from a DB backup. I need restore one table not database because I have update others tables in this database. thanks in advance kinds regards Abdel
I'm in trouble, I have just dropped a table from a sql dbase and now need to recreate it. I have no backup and I am panicking!!! I need to know if I can recrreate them .
I posted this a while back with no responses...does anyone know of another SQL Server discussion site that I can post this question to? I'm still having problems.
TIA,Mike
----8<-----original post-------------- I'm receiving the following error at one of my production sites and can't determine the problem. I'm restoring one table to tempdb, but the LOAD command isn't finding the table definition/address information in SYSOBJECTS for that table. I've ran a dbcc checktable on sysobjects and it's fine. Any other suggestions? (FYI - there are some errors when running a checkdb, but none on sysobjects - a FIX_AL is scheduled to be run soon.).
load table tempdb..acct_map_condition from disk = 'd:mssqlackupcarman.dump' with source = 'acct_map_condition'
Msg 4039, Level 10, State 1 Warning, file <1> on device 'd:mssqlackupcarman.dump' was dumped from database 'carman'. Msg 8409, Level 16, State 1 Invalid source table 'acct_map_condition' specified in LOAD TABLE. Could not find table in SYSOBJECTS in dump. Table load has been aborted for table 'acct_map_condition'.
Hi guys, How to make single table backup / or Restore individual table from the Database backup file.SQL server 6.5 got an option to do this...Anyone know in SQL 7.0 or 2000 I appreciate ur immediate reply! Thanks Rajeev
