Tag Info

New answers tagged

0

Found it, using this flag: --skip-lock-tables -f The schema still can't be exported correctly, except by using phpmyadmin


0

According the error message posted in the comments this is a faulty disk that cannot serve write requests (at a certain location).


0

The "Back Up Database" and "Save Database As" options do the same thing. The only real difference is that "Back Up Database" will provide a default file name like MyDatabase_2014-11-18.accdb whereas for "Save Database As" the new name will default to MyDatabase1.accdb They both do what is essentially a "Compact and Repair" into a new database file. ...


0

I dont know that much about Access backups but in general the benefit of the a backup is that it is unchanging. Take a backup and you have a snapshot of your data at that point in time. Just making a copy you run the risk of making a change in the copy and losing your snapshot. Of course with an Access file you can zip the copy to prevent changes.


1

I should have written this long ago, but better late than never. How did I resolve the issue? Each backup attempt created a dump file which I analyzed using WinDbg. These files indicated that the error originated in the sqlmin.dll assembly. I did a search for hotfixes for that assembly, found some, applied them, and after a reboot, the backups started ...


0

Also data pump can run in parallel, and has the option to append data, truncate tables or replace table. In addition you can change table spaces when you import. It is a better utility in every way than the older exp/imp tool.


1

Datapump is much more efficient than exp: Datapump runs within the Oracle server processes, and can read directly from the database files and write directly to a file on the server. As I understand it, data access is direct, not via SQL. exp uses the ordinary Oracle Call Interface (OCI) -- the library that Oracle provides to connect to the database. It can ...


0

Actually the problem was that some database procedures who did following tasks stopped working due to some newly introduced errors. The procedures performed below tasks:- summarize the data insert summary data in other table truncate table (to reduce the size and prevent creation of new table) That is why almost 15K+ tables were created due to this ...


1

The easiest way to setup an alert is to base it off the error number that occurs for failed backups. That would be error 3041. To setup the Alert USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Failed Backup Alert', @message_id=3041, @severity=0, @enabled=1, @delay_between_responses=0, ...


1

Note: This is for Microsoft SQL Server. For testing purpose, I downloaded a corrupt database backup file from SQLSkills.com Below is a quick script that will help you (obviously you can adapt the logic to do it dynamically for all your databases and send email in a nice HTML format) : begin try BACKUP DATABASE broken TO ...


0

This is a network timeout issue. You can troubleshoot this with your network team or by running a network packet trace that is filtered to SMB traffic between the SQL Server and the destination file server. A word of caution, this trace will be intensive with the tools that I am recommending and I have had mixed success with them (I last used it in an ...


1

Well based on Reason:15105 I think that SQL Server doesn't have permission to access to the path you check the permissions of the account that is assigned to the SQL service account? or other reason would be that there is not enough free space to create backup.


4

Code gets backup history for all databases on a server and generates HTML report Step 1: DECLARE @Body VARCHAR(MAX), @TableHead VARCHAR(MAX), @TableTail VARCHAR(MAX) SET NoCount ON ; SET @TableTail = '</body></html>' ; SET @TableHead = '<html><head>' + '<style>' + 'td {border: ...



Top 50 recent answers are included