Third Party Backup Programs
Feb 27, 2002
Currently we are using SQL Servers Backup utility to backup our databases to disk and then the files to backup tape during a nightly backup.
The time it takes for the backups to disk to complete for the databases is becoming prohibitively long and performance problems on the DB server are manifesting.
I am interested in other solutions. However, the propaganda listed at the various companies sites are less than insightful.
I was wondering if anyone used a third party Agent like Brightstor Enterprise SQL Server backup agent, or Veritas NetBackup for SQL Server, that would be willing to give some recommendations. If you use something that isn't listed here and it works well, I would be interested in hearing about it.
Do these backup agents significantly slow down the database performance? Do they create any locking issues? Some insight into your backup hardware configuration would be helpful as well. Thanks in advance for your help.
View 1 Replies
ADVERTISEMENT
Apr 30, 2007
Help Please!!!!
Anyone has an idea on how to call the back up and restore feature of SLQ server using Visual basic. Please help......Thanks
View 4 Replies
View Related
Apr 15, 2008
In your own opinions, what is the best backup tool for SQL Server, taking value for money into account where possible.
I am looking to purchase 3rd party software for my company and would greatly appreciate your suggestions.
Thanks.
View 1 Replies
View Related
Apr 25, 2007
We are looking at providing a Disaster Restoration Plan for our customers and would like to know what advantages does Mirroring have over Commvault Galaxy OR do we use them together?
thanks.
View 1 Replies
View Related
Sep 2, 2005
Can SQL 2000 initiate backups to 3rd party applications (like LiteSpeedand BrightStor's SQL Backup Agent)? My goal is to be able to managebackup and restores completely through SQL Enterprise Manager and QueryAnalyzer without having to logon to the Server and using the 3rd partybackup application's software. Is this possible through SQL?Thank you,Stephanie
View 1 Replies
View Related
Jun 1, 2007
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?
View 3 Replies
View Related
Dec 17, 2006
i repaired my problem with the SQLserver Express.....now i know how to use....but nowadays i have some problems with my DataBase....i would like you people share your DataBase to see what is my problem......mi msn is jmontes32@hotmail.com .......if you give some programs....i will learn more about SQL server..
sorry if you find some grammmathical mistakes....i'm learnig english
see you
jamie
View 4 Replies
View Related
Apr 16, 2008
we have an existing .c file and we have to include sql statements in it...
if we include sql statements it has to be stored as .ec file...
so we have to create a .ec file separately and include this into the .c program
but only .c and .h files can be included in .c programs so we converted .ec to .c file using esql command
now after incluing the .c file into the program we dont get any error but we are getting some junk output....
can someone help me in this
View 1 Replies
View Related
Mar 10, 2006
I need to install a sqlexpress on a company's server computer, but they are worried about whether it will cause any problems they said they got a Exchange Server installed, they wonder if that is gonna cause any problems?
Personally I never try that, but I dont' think microsoft will let this kind things happen...
do anyone can confirm that ?
View 1 Replies
View Related
Aug 11, 2006
hi,
i have a vb.net progi which i want to run under sql server 2005 as CLR.
the prob is that when i want to create the assembly in sql 2005 it says
that the create of the Interop.FC_COM.dll (this is the COM interop object) failed.
when i try to create the Interop.FC_COM.dll as an assembly in sql 2005 it fails because this dll is not follwing the structure of a CLR dll.
i've heard somewhere that MS is not supporting COM objects under CLR directly. is that true?
any comments welcome,
thnx
View 2 Replies
View Related
Apr 13, 2007
Hi,
my VB6 programs that use ADO to access SQL or Access databases do not work in Windows Vista. While they run smoothly in all older Windows versions, they fail in Windows Vista environments. Especially, the ADO connection does not work anymore. The same connection strings that work perfectly in all older Windows versions, do not work in Windows Vista. The error message sent by ADO is this: Runtime error -2147217887 - "Multiple-step OLE DB operation generated errors". And, not only I get this error message on my development systems, but all other users of my programs on all Windows Vista systems.
I have been playing around with alternative connections strings, but no alternative works.
Can anybody explain this? And is there a remedy?
Any help is highly appreciated.
Hermann
View 8 Replies
View Related
Dec 17, 2007
I am trying to install SQL 2005 that came with my Visual Studio 2008 on my Vista Machine, it will install successfully, but when I want to get to say, the Management Studio, or the Configuration Manager, there is no "Microsoft SQL 2005" node in my All Programs. what gives? you kind of need those. thanks.
View 1 Replies
View Related
Nov 21, 2007
Hi
I am planning to start working with Service Broker.
I got two applications from different providers. They use the same data; I mean both of them have a table €œOrders€?. They also provide a table called €œorder interface€?. This interface reflects the changes made in the table €œOrders€?.
I need to synchronise both applications. For this propose I would like to use the Service Broker and stored procedures as Service programs. Is it fine, if I start the stored procedure (Service programs) from a trigger in the tables (order interface)?
View 1 Replies
View Related
Jul 9, 2007
Hello all, does anyone know of a SS2005RS user audit program that an administrator can run on a RS server to show which userids have access to folders? I have in mind a pgm that would show:
folder users
Home user01, user02, user03
folderA user01,user02, user05
folderB user02, user06
Is there a pgm available as a download, or does someone have a home-grown pgm whose source they would let out?
Has anyone else faced this need?
Thanks in advance
View 3 Replies
View Related
Oct 24, 2007
I apologize up front since this question seems so basic but I'm really running into difficulty with it. Should there be a Visual Studio Express program to launch under Start - All Programs or do you simply have to select one of the pieces such as Microsoft Visual Web Developer 2005 Express Edition? I have seen documentation telling the user to launch Visual Studio Express yet I have nothing for that. Also, since I'm trying to become familiar with Reporting Services I suspect it's somewhere I haven't located yet, leading me to believe perhaps I'm missing something very, very basic. Thank you in advance.
View 4 Replies
View Related
Mar 26, 2008
I am having trouble installing SQL Server 2005 Express. I was told to uninstall and reinstall clean but now SQL Server does NOT show in the Add/Remove Program list but when I try to install, my system says I already have SQL Server installed. I get error messages every time. Any ideas???
View 2 Replies
View Related
May 17, 2007
Hi,
Is there as way to access SQL SErver DB for DML Operations from C++ programs in UNIX/LINUX. The current approach is by uisng Pro C to connect to ORACLE from C++. But I want to connect to SQL Server 2005.
Regards,
Kart
View 3 Replies
View Related
Apr 5, 2007
Could someone from the SQL Server Express team confirm that SQL Server Express SP2 w/Advanced Services shows up as "SQL Server 2005" in the installed programs list? The "Express" portion seems to be missing. And how would one tell the difference between the Standard Edition and the Express Edition based on this?
Thanks.
View 1 Replies
View Related
Jul 7, 2006
I went through the install of the MS SQL Server 2005 Std Edt only to find that I can not open up the "SQL Server Business Intelligence Development Studio" since I was missing the exe to run it that should have been located at "C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe". Due to this happening it seemed to me that some of the install failed, so I went about trying to uninstall the SQL Server setup. Within the "Add or Remove Programs" tool I selected the "Microsoft SQL Server 2005" from the list and clicked on the button that said "Remove". This did not seem to do anything except for remove the "Microsoft SQL Server 2005" selection from that tool selection list. It went way to quick and did not display any dialogs as it removed the engine. Also I can still opent the Management Studio and see all the normal stuff and I can query the data within the databases. The two part question is...
1) How do I get the Microsoft SQL Server 2005 program relisted in the "Add or Remove Programs" tool's selection list?
2) How do I get the "SQL Server Business Intelligence Development Studio" installed correctly?
The only warning message I received during the install was in regards to the hardware not being quite up to par with amount of RAM. I saw no errors within the install tool.
Thanks in advance for any help you can offer!!! Please let me know if anything else is needed to answer this question.
View 4 Replies
View Related
Nov 27, 2007
Is
"Microsoft SQL Server 2005 Mobile [ENU] Developer Tools"
equal to
"Microsoft SQL Server 2005 Mobile Edition"?
If not, what is it?
View 8 Replies
View Related
Jul 17, 2007
I have Microsoft SQL Server 2005 Express Edition Toolkit installed but there is something from with the installation since every time that I try and create a Report Server Project It gives me error
Could not load file or assembly "Microsoft.ReportingServices.Designer, Version 9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannopt find the file spesified.
How can I reinstall it or repair the installation so it will work. I have uninstalled every SQL2000 component in Add Remove Programs and reinstalled them. The problem is however that I cannot see an entry for "Microsoft SQL Server 2005 Express Edition Toolkit" in the Add Remove programs in Windows XP Profesional.
Can someone please help me. Maybe tell me where the uninstall file is located on disk??
Any help will be great
Manu Thanks
View 2 Replies
View Related
May 1, 2001
Hi All,
I have to load data from from a text file ( approx 3-5 million rows) into a table .
I can use straight bcp with the format file , but the loading of data has to follow some business logic
Let me know if there are any third party tool to load the data instead of regular bcp
I have SqlServer 7.0 on Windows NT 4.0
Thanks in advance
View 2 Replies
View Related
Oct 13, 2005
Does anyone know any software to backup single tables ? i recall one software that extracts the data into a text file called SQLinsert or something but wondering if they are others around ?
View 1 Replies
View Related
Apr 27, 2008
hello,
what are some good db managements tools that are available? I installed Toad from Quest and the Red Gate's toolbelt but I haven't play with them yet. I would like to know what is the most useful tool to invest time in.
Thanks.
View 1 Replies
View Related
Sep 12, 2007
Hey guys I really need your help.
We've outsourced our software last year, and it really a big mess for us since that company has been clashed. Then it so happened that the system failed to function well. Our batch transactions was working about 56 mins.. that is 24 records. Then it happened that this time 28 records was finished for about an hour. Our business hour is 8 hours only. That's why we have a back log now. We also failed to validate transaction since it takes a lot of effort before we update the database. It's working before but as our database becomes larger there are many errors occur in our application. Majority is runtime error. Then it happened that now we cannot move on anymore. We are using SQL server 2000 with VB6.0 application. our server memory is 1GB. Do you think adding additional memory will solve our problem?
Thanks!!
View 1 Replies
View Related
Jul 20, 2005
I prefer to write SQL code, without graphical tools.Have third party Query Analyzer that has filter and sort abilities?Also I looking for SQL editor with Completion ability (like we know forprogramming lang),for assist me write more quickly.
View 1 Replies
View Related
Oct 24, 2006
I am working on a SSIS package to move data between SQL2005 and DB2. I currently have the DB2 ADO .Net connector from DataDirect which works fine for connecting to the AS400. My question is that I am working on a script transformation and I want to be able to use the Connection already created in the package their.
I can set it up just fine using the properties for the script, but there appears to be no way to create SQLCommands and connections unless I reference the DataDirector DLL in the script, which requires adding it to the GAC and the Framework folder.
I am just wondering if this is the correct way to go about this or if there are any other recommendations. Please let me know if I need to supply more information.
Thanks,
Chris
View 1 Replies
View Related
Apr 11, 2002
I have been using the built-in tools of SQL Server (email and netsend) to monitor and alert me about some basic issues (like severity errors and job failures) with our SQL servers. We are now approaching a level and number of servers where I think we need to get a more global and more stable solution to monitoring and alerting.
So what third party tools are you are using to monitor your SQL Servers?
Thanks
SJ
shawn.johnson@kenexa.com
View 2 Replies
View Related
Sep 6, 2005
Hi All,
I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).
My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.
Is there a third party or open source search engine available?
Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?
Many thanks,
Newbie
View 4 Replies
View Related
Oct 30, 2007
The only way I know of to debug a Sql 2005 stored proc is to create a VS2005 Database Project and step into it from there. Does anyone know of any third party tools that adds functionality to Sql Management Studio to step into stored procs?
View 5 Replies
View Related
Jul 23, 2005
Folks,I work on a system which is growing rapidly, with the number oftransactions we process growing on a daily basis. While this is goodnews or the business, maintenance is starting to become an issue as thedatabase is the backend for a website which cannot be down for alengthy period of time.While I do defrag the indexes, periodically the indexes do need to berebuilt. When this happens, the process locks pages and transactionsstart getting bounced out.Are their any third party utilities which will rebuild an indexwithout this locking occuring? Any help in pointing me in the rightdirection would be appreciated.
View 1 Replies
View Related
Jul 20, 2005
I am looking for a better way to schedule jobs in SQL Server. I foundthis tool called SQLschedule at www.idera.com and am using the 30 daytrial. This tool really has a cool GUI, and seems to work well. Doesanyone else have any experience with their tools?
View 1 Replies
View Related
Mar 19, 2007
Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS? I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from.
R
View 4 Replies
View Related
