Tuesday, July 2, 2013

[MS SQL Server] How to troubleshoot error 3041? "BACKUP failed to complete the command BACKUP DATABASE XXXXX. Check the backup application log for detailed messages."

[MS SQL Server] How to troubleshoot error 3041? "BACKUP failed to complete the command BACKUP DATABASE XXXXX. Check the backup application log for detailed messages."

How to troubleshoot error 3041? "BACKUP failed to complete the command BACKUP DATABASE XXXXX. Check the backup application log for detailed messages."

Posted: 22 Sep 2011 06:58 AM PDT

My backups have been failing and I noticed the following in the SQL ERRORLOG[quote]2011-09-21 22:13:49.70 Backup Database backed up. Database: ...2011-09-21 22:13:50.68 Backup Database backed up. Database: ...2011-09-21 22:13:51.86 Backup Database backed up. Database: ...2011-09-21 22:29:25.51 Backup Error: 3041, Severity: 16, State: 1.2011-09-21 22:29:25.51 Backup BACKUP failed to complete the command BACKUP DATABASE XXXXX. Check the backup application log for detailed messages.[/quote]There is no other information as to what might be causing this.Where is the backup application log??

Help with contents of a script

Posted: 02 Jul 2013 04:27 AM PDT

Hi all, im the first to admit im rather useless when it comes to SQL (at the moment)I've contacted the 3rd party that is responsible for the database about our growing transaction logs, who have given me a script which shrinks the logs. Before I put this in, im curious as to what it actually does. I know I could contact the third party but it would probably take around 2 weeks to get an answer from anyone. Ive managed to reverse engineer parts of it but other parts im pretty stuck with. If anyone could let me know if im on the right lines with what i've put id be greatfull. The scrit is below, ive put REM next to the parts that ive managed to figure out:-----------------------------------------------------------------------------------------------------@echo offREM checks for servername\instance (%1) and database name (%2) has been included in the syntaxif .%1==. goto DisplayUsageif .%2==. goto DisplayUsageREM Stores the below commands into a file called shrink.sql in the temp folderecho shrinking log file for database %2echo.echo declare @sql nvarchar(255), @fn sysname > "%temp%\shrink.sql"echo set @sql = 'alter database [%2] set recovery simple' >> "%temp%\shrink.sql"echo exec sp_executesql @sql >> "%temp%\shrink.sql"echo select @fn = name from sys.database_files where type = 1 >> "%temp%\shrink.sql"echo dbcc shrinkfile(@fn,1) >> "%temp%\shrink.sql"echo. >> "%temp%\shrink.sql"echo.REM -S sets SQL Server Name and Instance to what is stored in %1REM -d sets the database name to what is stored in %2REM -U sets username to SAREM -P Sets Password to ?S1M5455796?REM -n Removes numbering and the prompt symbol (>) from input linesREM -i sets input file to "%temp\shrink.sql" which contains the commandsosql -S %1 -d %2 -Uusername -Ppassword -n -i"%temp%\shrink.sql"echo.goto Exit:DisplayUsageecho Shink the log file of a SQL Database v2.00echo.echo Usage: ShrinkDBLog {Server}\{Instance} {DatabaseName}echo.echo Where:echo Server\Instance is the SQL Server and the SQL Server Instance if one is presentecho DatabaseName SQL database name to shrink, eg simsecho.echo Examples:echo ShrinkDBLog AdminPC\SIMS simsecho ShrinkDBLog AnotherPC sims------------------------------------------------------------------------------------------------------This is the part where im not really sure whats going on? I know it stores the commands in shrink.sql but im not sure what exactly the commands do? Ive managed to figure out TYPE1 = Log files?declare @sql nvarchar(255), @fn sysname > "%temp%\shrink.sql"set @sql = 'alter database [%2] set recovery simple' >> "%temp%\shrink.sql"exec sp_executesql @sql >> "%temp%\shrink.sql"select @fn = name from sys.database_files where type = 1 >> "%temp%\shrink.sql"dbcc shrinkfile(@fn,1) >> "%temp%\shrink.sql"echo. >> "%temp%\shrink.sql"

litespeed restore

Posted: 02 Jul 2013 02:35 AM PDT

we have db backup file(litespeed backup file).Litespeed is not installed in the server.we need a command to restore the litespeed backup file.

Linked server issue

Posted: 02 Jul 2013 04:26 AM PDT

We've had an issue for several days now that I'm hoping you can weigh in on. We're testing a linked server between two SQL Servers. The first server, we'll call it server A for this discussion, is SQL2000. On server A we've defined a linked server to server B, which is SQL2008. The linked server's security is defined as "be made using the login's current security context". Both servers are on the same domain. We log onto server A with a Windows authenticated logon which is defined on the same domain as the SQL Servers. This logon is also defined on server B. When we attempt to execute a query that selects from a table on server B we get this error message:"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON"If we log onto server A with a SQL authenticated logon that is on both servers we do not get the error.

Monitoring Your Database with SQL Profiler

Posted: 02 Jul 2013 04:13 AM PDT

Is there any way to identify if someone is running "Monitoring Your Database with SQL Profiler" sql trace against production database. ? We are having issue with our current application performance, after diagnosing the problem, we realized one of our database admin decided to use this tools during peak hours that effect application performance. Is there any way we can setup some notification in case, if any other admin decided to follow hand on training for sql trace ?

Probably a very dumb file size question...

Posted: 02 Jul 2013 04:08 AM PDT

So I was adjusting the size of a DB for a customer (increasing the size of his QA DB) and noticed something. SQL will let you set an initial size that is larger than the maximum size in Autogrowth.So, my question, what happens if you do this? If you create a DB (or increase the initial size of a DB) so that, for example, the initial size is 10MB while the maximum size in Autogrowth is 5MB. What would SQL do? Still tell you that there's no space in the DB, or would it let you go up to the new initial size but not beyond?Just curious, and don't have a system handy to try this out on...Jason

dbWarden questions

Posted: 15 Apr 2013 03:48 AM PDT

Hello --I am trying out the dbWarden application by running it within the 2008 Standard R2 SQL Studio application. It appears to have executed successfully, but I am having trouble identifying and locating the output file. Can anyone provide information on this? Thanks.

SQL server restart

Posted: 02 Jul 2013 03:07 AM PDT

I see the SQL server restarted last night. I don't know who did that or it is an automatic restart.As far as I know there should not be anybody doing that, how can I know if it is automatic restart or somebody did it from the logs?Thanks

SQL Server 2008 R2 , change domain

Posted: 02 Jul 2013 03:01 AM PDT

SQL Server 2008 R2Ho guys I need some help from you:I have a SQL Server 2008 R2 installation in a domain.The IT department has decided to change the domain name (keeping same name and IP).Could you provide me the direction on how to ensure the SQL Server still works after the domain change without any issue?Many thanks

change dbo login name

Posted: 01 Jul 2013 08:37 AM PDT

I have a database that I need to change the dbo owner from user A to user B. I'm getting different errors.When I try to change it I get the error that the user B is already mapped. What's the process to change the owner of a database?When I ran the scrip belowselectu.name, s.namefrom sysusers uinner join master.dbo.syslogins son u.sid = s.sidI get:name namedbo domain\userAdomain\userB domain\UserBI tried dropping user B but I cannot change the db owner to userBThank you.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog