I asked question while back about Log PI tool, it did not get any replies but I found out it is no longer supported and developed. Now I would like some feedback about other tools that can help with log recovery. I heard about Lumigent, Red Gate and Apex SQL. Any more alternatives? Also I would like your feedback about customer support, pricing, updates, features etc.
Thank you
I have a small, ~10GB SQL 2008 R2 database, that was setup with simple recovery. We do full backup each night at midnight when no one is using the database. Is there any problems with doing differential backups during the day when users may be writing to the database? Could I even do hourly differential backups while users are using the database? I'm conflicted about switching over to full recovery mode and using transaction logs to have the ability restore data between backups. If I can do a couple daily differential backups while users are using the database during the day, in addition to our nightly full backups, than I live with simple recovery mode.
View 3 Replies View RelatedWonder if somebody know if it exist som tools that makes it possible to geta graphical overview of relationships between C# source code components andtheir's interaction with the database tables/elemts (E.g SQL serverdatabase)A typecial rewengineering tool to get a grasp of a system with manycomponents acessing multiple tables in a rdm system.A tool that parses the C# code for sql/(databse interaction) and presentsthe interaction grahical in som way?Many thanksAksel
View 3 Replies View RelatedAm customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies View RelatedThe installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068052700
Exit facility code: 1212
Exit error code: 1316
[code]...
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?
Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.
Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?
Where would I find the version "bytes" in a BAK file?
We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.
View 6 Replies View Relatedis bulk logged recovery model support point in time recovery
View 9 Replies View RelatedPages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.
View 4 Replies View Relatedin the process of migrating a big db from server 1 to server 2, we had to roll back the change. I started with taking a full db backup and restoring it on server 2 with norecovery, and then a couple logs with norecovery, and then the last log with recovery.
Is there some way to continue this chain now, I mean to change the db to norecovery, or other way to restore logs.
I dont want to do a new full backup.
If I try to do a log restore now i get the message:
Msg 3117, Level 16, State 4, Line 1
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
We have 3 replica AG setup. 2 replicas are in sync/automatic failover, the other(DR Server, different subnet) in asynchronous/manual mode…All these replicas were on sql server 2012, Recently we upgraded DR server to 2014. Since then we have a problem, the AG databases in 2014 instance went into ‘Synchronizing/ in recovery’ state…The SQL server error log has message, the recovery couldn’t start for the database ‘XYZ’…We tried to create a new database and add it to AG , it works for fine for other two 2012 replicas, but on 2014 we see the same issue
View 3 Replies View RelatedDear All,
how can we know that wether we had server tools or client tools on my machine?
Arnav
Even you learn 1%, Learn it with 100% confidence.
We have an issue with a 3 node SQL 2012 Always on availability group. Normal operation is node 1 (primary replica) with node 2 and node 3 as secondary replicas.After some patching, SQL wasn't running on node 1 hence the AG flipped over to node 2. This went unnoticed for some time and the transaction log for one of the AG databases became full on node 2 and node 3. (I think this is because it couldn't commit the transactions on node 1 so couldn't truncate it's t-log?) The DB is using synchronous replication btw.So I started SQL on node 1 and flipped the AG back to node 1 (with a data loss warning but I accepted this).Now the issue is that on node 2 and 3, the DB in question is stuck in a "Reverting / In Recovery" State. I've tried various commands such as ALTER DATABASE SET ONLINE, RESTORE DATABASE WITH RECOVERY etc but these fail stating unable to obtain a lock on the DB.
The weird thing is that on node 1 the state of the DB is "synchronised".how to resolve this issue on node 2 and 3? I've left them overnight (in case they were rolling back transactions, the DB is fairly large) but nothing seems to have happened. remove the DB from the AG in node 2 and 3 and add it back in again, ie recreate the replication?
Know any good performance monitoring and analysis tools for SQL server.
View 1 Replies View RelatedIf you are doing a disaster recovery of an entire SQL 2005 cluster, can you just install SQL server and restore the system database to get the configuration?
View 4 Replies View RelatedIs there a tools simular to php admin. for MS SQL? If not how can you view the data without writing a query? ThanksDee
View 6 Replies View RelatedHi,
Is there a way to determine whether sql tool are installed on a client machine. DTS wouldn't run without sql tools.
Is there a workaround?
TIA
Barath
Is anyone aware of a tool, utility or Stored Procedure that would allow you to compare stored procedures on diferent servers and to copy stored procedures from one server to another (eg. test to prod).
Thanks,
Ken Nicholson
Can anyone recommend any tools or bundles that are out there for MSSQL databases used for comparing and syncronizing stucture, data, stored procs, etc.
I'd like to hear about any and all.
Hi guys,
for one of our forthcoming sql project.
I need your inputs/recommedations on the tools and techniques widely used in SQL SERVER based on the following parameters
Design efficient schemas
optimizing queries, stored procedures
fine - tuning indexes
Performing efficient transactions
analyze and understand execution plans
Scalability pitfalls
Test and monitor data access performance
Generate historical and reporting data
Processor,memory and performance related bottlenecks
DISK I/O related bottlenecks.
SQL IN Minds
Hello,
what tools do you usually use for DBA job, like performance monitoring and performance tuning etc?
Thanks
I planning some web app that I would like to use MSDE to power. I admit I am intimidated by the thought of creating databases with no GUI. So my question is can I use SQL server 2000 tools with MSDE or can I create databases with SQL server 2000 then deploy them to a machine running MSDE?
Thanks
Does anyone know of any good debugging tools for transact sql? I know there is one by compuware called dbpartner but was looking for other options.
Thanks,
Eddie
Hi
Can anyone suggest me a good case tools that works fine with SQL Server. We have old version of ERwin and we like to upgrade. The decision is whether to upgrade ERwin or go for any other tools better than ERWin.
Thanks in Advance.
Jaya
What's my question is ? Whether there are any tools available for normalization produced by Database vendors or any third party. If yes, Can u kindly give me clear documentation.
Thanks,
venkat.
venkat_26178@yahoo.com
whether there are any tools for Normalization? If yes, Can u please send some documentation or some reference where I can get them.
-venkat
venkat_26178@yahoo.com
I need to be able to administer SQL 6.5 and 7.0 servers from a single pc.
I have been told that I can't have SQL 6.5 and 7.0 tools installed on the same pc.
Is this correct? I can't find anything in BOL or Technet on the subject.
Regards,
Kevin Napier
Hi Guys
I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message:
The SQLOLE OLE object could not be registered. Class not registered (80040154)
After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled.
Still no luck.
Any ideas?
Many thanks
Stuza
can anyone tell me where can download stress testing tool for SQL Server 7.0.
Thank You,
Piyush Patel
Hi,
What are the best tools for web reporting that can extract data from sql
server and also draw graphs.
thanks
We are evaluating a tool by Lechotech that can optimize sql statements. It is a pretty good tool, but we would like to compare it against some others. Has anyone seen any other such tools?
View 1 Replies View Related