Dump Database Vs. Sqlmaint.exe -bkupdb

Oct 25, 1999

Both "dump database" and "sqlmaint.exe -bkupdb" would be able to backup database, one important advantage I can see from "sqlmaint" is that it has the option to cleanup the very old generations of backups by using -delbkups option in a scheduled maintenance backup job, while the "dump database" would first create a dump device and it'll grow with time.
Is there any suggested way to use the "dump transaction" but still we can get control on the size of dasd used ?
Any negative part of using "sqlmaint" utitity to backup database as compared to the "dump database " utility ?
Anthony

View 3 Replies


ADVERTISEMENT

SQLMaint Insists On DUMP DATABASE

Oct 13, 1999

We run SQLMaint hourly ( as a scheduled task ) to clear our transaction logs. Last night our hard drive filled up during a log dump, causing SQLMaint to fail, and a subsequent transaction filled up the log.

We succeeded in manually truncating and clearing the log, but SQLMaint still insists on us doing a DUMP DATABASE to clear the logs before it will run again. Unfortunately, we do not have enough space left on our hard drive to do a full database dump.

Is there any way of fooling SQLMaint into believing that a DUMP has been run? Some flag in a system table somewhere, or maybe a registry entry?

John Morrison
Hurst, TX

View 2 Replies View Related

How To Dump Database

Mar 6, 2000

Hi,

I need a good suggestion from you.

1. I need to create a replication enviroment. In that i want to snapshot the database as and when i want from my Java program, so that selective tables are updated with latest data. Is there anyway i can do with out creating native replication methods.

2. Is there any way with out creating a snapshot or replication. I need to copy the data from my master database to child database(my reporting database) with out straining much my master database

Thanks in advance

Regards Jagannadh

View 1 Replies View Related

Database Dump

Oct 5, 2000

Hi people

when doing a dump on a Win2000/SQL7 database from and NT4/SQL6 machine I get the following error:

SqlDumpExceptionHandler*****
EXEPTION_ACCESS_VIOLATION. SqlServer is terminating the process.

Can anybody tell me why?
What should I do?

Tks
De waal

View 1 Replies View Related

Dump Database

Aug 3, 1999

Hi all,

When I use "DUMP DATABASE", it will help me to backup both database and
transaction log. However, it will not help me to clean up the transaction log.
Therefore, I am worry that will the following happen?

1. DUMP DATABASE
Start backup database
( there are transactions during the backup process )
Finish backup database
Start backup transaction
Finish backup transaction

2. DUMP TRANSACTION
Start backup transaction and clean up the transaction log

So, will the transactions been backuped twice? If yes, will it cause those
transaction do twice when I restore the database then restore the transaction?

Thanks

View 2 Replies View Related

DUMP DATABASE

Aug 10, 1998

Hello, All!
Can anyone explain what happens to Transaction Log
when DUMP DATABASE is issued?

Thanx.
John.

View 1 Replies View Related

How Do You Dump A Database With MS SQL?

Jul 20, 2005

Tried googling, but I guess I have the wrong terminology for MSproducts.Using PostgreSQL, or MySQL, if I wanted to tranfer a database from onemachine to another, I'd do a "dump" with a single command, such as:mysqldump [databasename] > [path/filename]Then I'd take the file generated and dump it back onto a new machine.What's the process with MS SQL Server? Can someone point me in theright direction to a webpage dealing with this?--[ Sugapablo ][ http://www.sugapablo.com <--music ][ http://www.sugapablo.net <--personal ][ Join Bytes! <--jabber IM ]

View 3 Replies View Related

Dump Database To Network

Sep 29, 2000

I am trying to backup database on a network disk using isql
dump database <DBNAME> to disk = 'servernamepathfile.ext' with INIT

but this does not work and gives an error device off line.
How can I do this??

Thanks

View 1 Replies View Related

Creation Of Database From Dump

Aug 29, 2006

Hello,

I have a SQL database dump with me. I would like to create a database using the dump. Could somebody help me with the steps?

Thanks :)

View 1 Replies View Related

How To Dump Database To MSDE

Dec 7, 2006

Hi

In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net

1.how to dump my sqlserver database which i was already using to theMSDE and

2.can i connect this MSDE to MSSqlServer2000

View 3 Replies View Related

Cross Server Database Dump

Oct 5, 2004

I am attempting to remember the string to dump/restore a database to a different physical server.

I have the database on Server 1 and want to back it up to server 2. Can anyone refresh my memory?

Thanks

View 2 Replies View Related

Newbie : Dump The Log On Distribution Database ?

Apr 12, 2001

Hi there,

I'm a newbie. I've installed a replication between 2 NT4 servers, with SQL 6.5. My logreader tasks has crashed "Can't allocate space for objects 'syslogs' in database 'distribution' etc...". With a DBCC SQLPERF(LOGSPACE) I can see that the log is 100% full, but I can't dump it : when I use DUMP TRAN DISTRIBUTION WITH NO_LOG, my distribution log is still 100% full. So how can I do to dump it and what can I do to prevent it from filling up ? Do I need to dump it like I do for my database but how could it work if a DUMP TRAN doesn't work ?

Thanks in advance.

Sorry for the English, it's not my native language.

View 2 Replies View Related

Scheduled Database Dump Dilemma

Mar 7, 1999

I am fairly new to SQL server and am having a problem getting the SQL backup or "dump" to do what I need it to do. My desired end result is to have a database backup every night to a backup device on the same server as SQL is running, and keep one weeks worth of databases in the backup device, overwriting the database backup from 7 days before. This device is then transferred sometime later to another server using the NT AT scheduler. The first time I tried to accomplish this I used Enterprise manager to schedule a full backup to be run each night at midnight. The backup device was set to be initialized and retained for 7 days. This procedure worked once, the first night. There after it failed. In looking at books on line it said that I needed to change the transact -SQL command from INIT to NOINIT as the INIT instruction was the cause of the failure. I changed the statement in the Scheduled Task manager to NOINIT. That seemed to do the trick as I checked the backup device each of the next few days and saw that it was indeed performing the backup and retainng the databases. A week later I checked the backup device again and found that it is still adding database dumps to the file, but it is not overwriting the dumps that are 7 days old. I am told that I need the INIT statement in the dumpdevice command in order for the RETAIN DAYS = command to kick in. However, this did not work before. I can not continue adding to the dump device as it will get too large and take up too much disk space on the server. The only way I can get the device to a reasonable size is to do a backup and initialize the device, which gets rid of all of the older databases. This seems like a catch 22. Is there any way I can make this work. I am running SQL 6.5 on the latest service pack (5a). Any help would be greatly appreciated.

View 4 Replies View Related

How To Find The Size Of The Database Dump.

Jul 20, 2005

hi,There is facility to do backup of the database. I can use thatfacility to backup the database. But before i do a backup i want tocheck if the disk space available enough to backup that database. Ihave a 22gb database mdf file, when i took a backup of that its only3gb. SO i cannot use the size of mdf file to determine the databasedump file. Is there any facility available to find out the backupdatabase dump size before doing the backup?ThanksNabhonil.

View 1 Replies View Related

How To Dump A Database From Mysql To Sql Server2005

Mar 16, 2007

Hi Every bdy,

I have a database which is in mysql. Now we want to port that database to Sql Server 2005. Please tell the steps to do this.

With Regards

Ravinder Reddy.K

View 6 Replies View Related

Dump Database Task Stops SQL Executive

Aug 18, 1998

We are running sql 6.5 with Serv. pack 4. All of our Prod. database are backedup weekly via scheduled tasks. On occasion the dump of a particular database will cause 1 of 2 things:
1. The db dump seems to work correctly but stops sql executive service.
2. The db dump seems to work correctly but sends an alert email msg to me indicating that it failed. The msg in the email is "NO Message".

Has anyone experienced either of these 2 problems or have any solutions?

View 1 Replies View Related

Importing A Single Table From A Database Dump?

Dec 5, 2005

I have a database dump using mysqldump. Now I want to import a table from the dump file. How would one do this?

I've used mysqlimport < table.sql, but what if I have databasedump.sql which includes all the tables, but I only want to import ONE table?

-D

View 4 Replies View Related

Using A Dump From One Database In Another Database

Nov 3, 1998

can a database dump created from one database be used in another database? what are the procedures?

thanks in advance

View 2 Replies View Related

Help!! SQLMAINT

Feb 7, 2002

Is anyone using the -DelBkUps option with their maintenance plan on
SQL 7.0?? if so is it actually deleting the files? Mine is running
but not deleting any of the old backup files.


thanks

View 1 Replies View Related

SQLMAINT 6.5

Oct 6, 1999

I would like to run the following SQLMAINT command on my database every
14days:

At 2:00 AM, this command needs to kick off: SQLMAINT.EXE -D cabinet
-CkAl -CkCat -UpdSts -RebldIdx 100 -Rpt D:MSSQLLOGcab_maint.rpt

Question: How can I "kill" all users, then place the database in "dbo"
mode, run "SQLMAINT", and then release database access back to the
public - all in an automated process.

Any suggestions would be "GREATLY" appreciated.

Thanks,
Chris

View 1 Replies View Related

SQLMaint.exe

Jan 15, 2002

Was wanting to get some feedback on using sqlmaint to produce database backups in a production environment. Especially on databases > 10GB. My preference is not to use it but I'm arguing with another DBA and wanted some outside feedback.

Thanks.
Carol

View 1 Replies View Related

Sqlmaint.exe

Jun 22, 2004

With MSDE 2K I get the following error message when trying to execute scheduled db maintenance/integrity checks:

"Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029). The step failed. "

The Microsoft website tells me this is because sqlmaint.exe is not installed and that installing the latest service pack will solve the problem.

I installed the SP3a and sqlmaint.exe is in the following location:

C:/MSDE/Binn

But I still get the error...

Any Ideas?

View 1 Replies View Related

SQLMAINT And Backups

Oct 30, 2001

I am a big fan of the backup naming convention used by maintenance plans and the SQLMAINT utility. My problem is that I want to use the same naming convention "db_name_diff_YYYYMMddhhmmss" because of my situation: I'm in California, my databases are in Pennsylvania, I don't have domain access to the servers, I use a scheduling tool (required) that only uses T-SQL or cmd line utilities, and I want the backups named as above. SQLMAINT provides for full and tlog backups, which I have set up, but I want to do diff backups the same way, with the same naming convention. Any ideas?

View 1 Replies View Related

Sqlmaint Cmd Line

Jan 10, 2000

I am having problems running sqlmaint against my servers.

From a command line I am running c:sqlmaint -S servername -U "username" -A "password" -D database -UpdSts as a test.

All i get is the list of arguments displayed. This never seems to work.

Any Ideas??

View 2 Replies View Related

SQLMAINT.EXE Locking Up

Feb 3, 1999

I run the SQLMAINT.EXE utility nightly to do DBCC checkdb, checkalloc, and checkcat checks on all databases. On one server this check seems to lock up the server displaying error 17832, "unable to read login packets". Once this occurs the only way we can find to get out is to reboot the NT Server. We have observed this behaviour once every two or three weeks. Anyone seen anything similar?

View 1 Replies View Related

MS SQL Question - SQLMAINT.exe

Dec 15, 1998

Does anyone know where I could get details on the various switches SqlMaint.exe offers and descriptions of each switches capabilities.

I know by typing in "sqlmaint", it will list all the various switches available but there is not description of what each one exactly means.

Thanks in advance. JLS

View 2 Replies View Related

Sqlmaint.exe Failed

Jun 5, 2001

Can anyone tell me how to troubleshoot the following error:
'sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.'

Thank you,

Ryan

View 2 Replies View Related

Sqlmaint.exe Failed

Sep 17, 2001

"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."

I get this error message when trying to execute one of the jobs created by the maintenance plan wizard.

Any ideas what caused this error?

View 2 Replies View Related

Question About Sqlmaint

Sep 22, 2005

hi guys !
I have a simple question , i am using the following command to backup transaction logs :

exec dbo.xp_sqlmaint '-D Northwind -BkUpMedia DISK -BkUpLog "d:sqlackup" -BkExt "TRN" '

does it truncate the tranlog after backup i.e remove the unused entries from there ?

thanks
Sami
P.S: can you please CC me with your answer at esa019c@motorola.com ?

View 1 Replies View Related

Sqlmaint.exe And -HTMLRpt

Apr 11, 2004

SQL2000 SP3a I would like to generate an HTML output file as a report which should be possible. After creating the maintenance plan using the wizard I used the created syntax and established a second job which now uses the changed syntax - however the job doesnt run. In the log file it just states the basic sqlmaint switches.
Current job syntax - SQL uses build in system account.

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 89CA81E2-181C-42F9- B39C-59EE21936079
-HTMLRpt "C:SystemDbs.html"
-DelHTMLRpt 1DAY
-VrfyBackup
-BkUpMedia DISK
-BkUpDB
-UseDefDir
-DelBkUps 2WEEKS
-CrBkSubDir
-BkExt "BAK"'

View 4 Replies View Related

Sqlmaint.exe Failed

Sep 12, 2005

I have a maintenance plan on a client's site, there's only one databasein the plan and it's set to backup db and log, this job failsconsistently. The one step in the job contains this line:EXECUTE master.dbo.xp_sqlmaint N'-PlanID392B2334-6800-4655-A6C7-5414D9072505 -WriteHistory -VrfyBackup-BkUpMedia DISK -BkUpDB "C:Program FilesMicrosoft SQLServerMSSQLBACKUPDailyBackups" -DelBkUps 4WEEKS -BkExt "BAK"'Which fails if run in QA with the message:Server: Msg 22029, Level 16, State 1, Line 0sqlmaint.exe failed.I've searched for this error and cannot find anything to help.There's no "-S" in the path, it writes absolutely no history on theplan. I set the plan to write history in the log directory on theserver, it wrote nothing to that directory.The database doesn't get backed up but is able to be backed up manuallyto the path specified in the plan. I also have a separate job with aSQL backup statement in it that works OK so SQLAgent is working.

View 9 Replies View Related

Sqlmaint.exe Failed

Sep 6, 2007



I am using SQL 2000,everyday we are running database backup plan but it shows a error like "Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
Our database recovery model is also in Full mode.Burt i don't know why its happening with us,before that database maintenance plan was working fine but for last 2 months its not working.

thanks,

-Amit

View 1 Replies View Related

SQLMAINT.EXE -- Returns Only The Switches

May 13, 2003

Hi,

I am trying to run the following:

SQLMAINT.EXE -USA -P -S abc -D db1 -CkDB -Rpt c:log_backup.rpt -DelTxtRpt 1days

But it simply returns the

SQLMaint switches and doesn't run the actual -CkDB?

Do I need to register any DLL to make this work ?

Thanks in advance,

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved