Scripting The Isql.exe To Export Date And Backup The DB SQL 2000
Aug 22, 2006
We have no certified SQL DBAs. Mainly because 95% of our production data is on Oracle and DB2 databases.
One of our Oracle DBAs is trying to write scripts that can be run by the AS400 robot to export data and backup the databases. I (being the only person with any SQL expierance) have been asked to ensure that the scripts she wrote will not only work but not bring down the server.
Can anyone point me to the correct place (web, book, ect) to find out how this is to be done? In years past my SQL servers have been stand alone dedicated units. With db backups scheduled through the SQL Manager and tape backups handled by the sysadmin.
Please help,
Cwells
View 1 Replies
ADVERTISEMENT
Sep 6, 2007
Hi All
I am using Sql Server 2000.
The database is being used since 5 years and the transaction file (mdf) has increased upto 12Gb.
We are thinking of reducing the size of the database and keeping only the data of the past 1 year. So I would like to know if there is some way of backup or export so that I can get latest 1 year data.
Thanking You All:S :S :S
View 3 Replies
View Related
Feb 17, 2004
Hi Everybody,
I am kind of new to MS SQL server databases. I like to take a full export at database level. When I use DTS wizard, it did allow me to take one table at a given time. I have 1000's of table in my database. Manually doing so is not possible. Should i call the 'bcp' command line utility 1000 times to collect the table data to 1000 different flatfiles or is there any provision to take export of all the 1000 tables in one single command/tool.
Many thanks.
View 8 Replies
View Related
Jul 28, 2004
I need to have an Application owner backup a SQL Server dbase after his updates.
Im not that familiar with ISQL. He does not have EM installed on his machine. What minimum installments do I have to do on his machine for him to log into SQL Server, after I create a login for him ?
Once in the command window I would give him the script of isql -Usa -Ppassword -SSqlServerA -Q "BACKUP DATABASE [test] TO DISK = N'E:Program FilesMicrosoft SQL ServerMSSQLBackupdbase1' WITH NOINIT , NOUNLOAD , NAME = N'test backup', NOSKIP , STATS = 10, NOFORMAT"
Is this the correct way to go ?
Thank you
View 4 Replies
View Related
Sep 23, 2005
Hi,I'm using isql to query data and output the same to a flat file.The isql has the following command options ' -h-1 -w500 -n -b -s"" '.In the SQL_CODE, the first two lines before the select statement areuse dbnameset nocount ongoWhen I run this, an additional blank line is put into the output file.Actually, there are two lines after the last result set in the outputfile. This file is being fed into another system and the blank line iscausing validation issues.How can I supress this blank line?This script is run from windows and the isql is called from a batscript.Batch script ...================================================== ========.....isql -Uuserid -Ppassword -Sserver -i"%SQL_CODE%" -h-1 -w500 -n -b -s""[color=blue][color=green]>>"%OUT_FILE%"[/color][/color]IF ERRORLEVEL 0 SET RC=0IF ERRORLEVEL 1 exit 4================================================== ========SQL code ...================================================== ========use punclaimset NOCOUNT ONGOselect * from XYZ;GO================================================== ========Your help is greatly appreciated.Yash
View 3 Replies
View Related
Jan 15, 2015
Execute a pre written SQL on double clicking a batch file which will then export the results to a csv.
View 5 Replies
View Related
Jun 11, 2004
Hi guys
I am relatively new to SQL Server admin and I have been handed a task of creating backup devices for a particular SQL Server which has 204 databases.
Rather than go through and create Full, Incramental and Transaction Log backup devices for each database is ther anyway of doing the following
Create a script to go through and for each database name in 'sysdatabases'
create a folder e.g sqldataackup\%databasename%
and within each folder create a backup device called
%databasename%_full
%databasename%_inc
%databasename%_log
Also all these databases are running in 'Simple' recovery mode so obviously I need to change this to 'Full' to enable incramental and log backups - is this possible using the same script.
Hope someone can help as the thought of doing all of this individually for each database scares me silly!!! :)
Thanks in advance for any help
Hanley
View 5 Replies
View Related
Mar 21, 2008
Hi, I've just been given the task of finding out how to implement a backup procedure for our SQL server databases. Most are running 2000, some 2005.
I'm a programmer, and I'm used to having a DBA to help me! I've seen a few methods on the web involving a stored procedure and running the task from task manager.
I need to backup and restore all the databases in SQL Server 2000 and work out a way of displaying whether or not it was successful.
Can anybody please point me in the right direction as I've no idea how to do any of this really. I guess if I could setup a sproc to loop through the databases that would help, but I'm not sure where to start.
Thanks in advance.
View 9 Replies
View Related
Mar 16, 2004
Hi to all
Is there any option in sql server DTS or any other third party tool that can script data. By scripting data i mean that....
if a table "Employee" contains 50 rows, i want the tool to write 50 insert queries for me so that i can run in it anywhere.
Problem is i have to insert data in a remote server where i cannot use DTS. I just have a text area to write my query and press the run button..
Hope u understand my problem. In case of any explanation please reply. Waiting for your response. Thanx in advance.
by to all
View 1 Replies
View Related
Dec 28, 2007
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
View 4 Replies
View Related
Jan 23, 2002
is there a quick T-SQL that backup a table to a file
that it is possible to restore the data in the future to the same table ?
Thanks
David
View 4 Replies
View Related
Jan 10, 2006
Please, can anyone sort this out for me?
What is the difference between backup-restore and export-import data?
Thanks in advance :rolleyes:
View 5 Replies
View Related
Nov 29, 2001
I want to know how people are backup up their win2k system and SQL 2000 server. If you want a run backup once a night and first backup win2k file system and then run backup using sql agent will that work?
Thanks.
View 2 Replies
View Related
Jul 19, 2007
I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.
Any ideas?
Thanks
Mike Mattix
View 8 Replies
View Related
Jul 23, 2005
I have a database file approximately 30GB in size which creates 3 datatables daily. I need to reduce the size of the DB due to disk sizelimitations. Could I EXPORT some tables, let us say over thirty daysold, to something like DB_Name_Archieve and them delete them from theproduction DB to reduce the size? I also need the ability toreference/read them at a later time as needed.As a side note, could SQL Server use data on a redirected drive i.e.NET Used. This would allow me to move the old tables to the redirecteddrive and reference them as needed.As always, thanks in advance.Peter
View 1 Replies
View Related
Oct 7, 2014
I have an msdb package to export data into a .csv file. It works well except every time i run this package it appends the data to .csv file. I need the .csv file to contain only new data, the old records has to be erased.
View 1 Replies
View Related
May 24, 2004
Hello,
I am trying to output data from my sql table to an excel spreadsheet and send it by email which works fine, the problem is he wants the date to be in the format d-mmm-yy, which is easy to format in excel manually, but he do not want to do this manually. I tried to do this when I select the date from the table to spreadsheet, "select convert(char,value_date,106) from table", but this don't get transported to the excel spreadsheet, I get my results on the spread sheet as dd/mm/yy. Can you please help either to set the date on excel forever to be in this format "d-mmm-yy" or to force this output to excel
View 1 Replies
View Related
Jul 20, 2005
Help!I have a table that has datetime format field, I exported the table toa csv while I dropped it and tried some other data, but now sqldoesn't recognise the date format for importing, heck I don't!The dates look something like:40:58.1Whick means nothing to me, or any of us here for that matter...Any ideas?John
View 1 Replies
View Related
Aug 30, 2007
I would like to export sql server 2005 tables to a text file using SSIS. It is easy to do this as a direct export. However, how could I separate the datetime field into two fields: one for date only and one for time only?
View 4 Replies
View Related
May 16, 2008
Hi,
I want to export the table data of a database in sql server 2000 to a text file.Is there a way I can do it through some query or command line. If yes can anyone tell me the query. I would like to avoid doing it through UI.
Regards,
Seena
View 8 Replies
View Related
Jun 2, 2008
I have a 2005 SQL SERVER db. I'm trying to export it to a 2000 db. I delete all the tables in the 2000 db then try to run an export from Management Studio 2005 and the tables go over fine, but no PK field is defined, no already-defined identity seed, etc...
View 8 Replies
View Related
Apr 24, 2006
hi, i installed sql server 2005 express on my tests server, i need to move a database from my sql server 2000 to test how it works with 2005.
i understood that the export/import option is not available in express version. but i still need to pass my database, other wise i cant check the power of the 2005 version.
please tell me about other way to do!
View 5 Replies
View Related
Feb 9, 2007
We're running SQL Server 2000 and our client is using Excel 2000. When
a report is exported to Excel they can't read them. Excel 2003 works fine.
We're both on SP4
How do I get it to export for Excel 2000?
Thanks,
Johnny
View 3 Replies
View Related
Apr 25, 2008
I've had issues where backup up and restoring data from sqlserver2005 does not reattach the data to the correct users. Any tips on how to best accomplish full database moves where data is owned by different security users?
thanks,
View 2 Replies
View Related
Mar 12, 2007
Hi,
How can I export data from multiple at once. In DTS wizard it only allow me to export one table at the time.
View 1 Replies
View Related
Sep 24, 2005
I was wondering if anyone knew how I could export data from SQL Server to a specific Excel worksheet with an Excel file, such as "Sheet2" or "Sheet3" for example, instead of dropping the data automatically in to Sheet1.
Thank you!
Dave
View 2 Replies
View Related
Apr 4, 2006
Hi,
I am a new SQL Server 2000. Can anyone assist me with how to export data from SQL Server 2000. Your help would be appreciated.
Dan
dan
View 1 Replies
View Related
Oct 15, 2007
hi,
i export datas from sql server 2000 to Ms Access. but few tables only not expot. and error has come "the microsoft jet data base engine cannot find the input or Query "<t.n>" make sure it exists and that its name is spelled correctly.
but tables are live in sql server 2000.
Please give solution as soon
View 3 Replies
View Related
Oct 22, 2007
hi,
i try to Import and export options in sql server 2000 but the fatal error is coming "Could not create instances of an DTS Package".
View 3 Replies
View Related
Jan 18, 2008
Hi every body
How can I export procedure from sql 2005 to sql 2000. I didn't see any options to do this. Thanks alot in advance...
View 2 Replies
View Related
Jul 23, 2005
Hi all,In MS SQL Management Console I can right-click on any Table and I havethe option All Tasks > Export Data where I can export the table toExcel. In a View however this isn't there. I have many views I wantto simply export to Excel, but the only way I've found to do it iscreating an ODBC connection to the MS SQL database from MS Access,linking the Views to Access Tables, and exporting from Access. surelythere's someway to export a View to Excel within MS SQL easily likeexporting a table...Thanks ---Alex
View 1 Replies
View Related
Aug 26, 2015
I have created an package in SSIS and getting some problem when i am export date from OLEDB to Excel its format getting change. I am passing date format MM/dd/yyyy and its showing yyyy-MM-dd.
View 2 Replies
View Related
Jun 19, 2004
Hello,
I am working on a couple fo the ASP.NET walkthoughs and I would like to practice with a Database that I created in Access. I realize that I could use the Access DB, but I would like to learn to work with a more industrial strength DB. Is there a method to export to MSSQL server 2000 from Access ?
Regards,
James
View 4 Replies
View Related
