Author Archives: cviorel - Page 3

DTExec: The package execution returned DTSER_FAILURE (1)

Posted by cviorel on September 11, 2014 No comments | This post has 1,113 views.

What to do when a SQL backup job created with SQL server Maintenance Plans fails with this error?

DTExec: The package execution returned DTSER_FAILURE (1).

1	DTExec: The package execution returned DTSER_FAILURE (1).

Investigate! No useful information in the logs.
Previously that day I dropped a few unneeded databases so maybe the Maintenance Plan was still referencing them. Everything looked good when the Maintenance Plan was opened in SSMS (it was configured to backup “SELECTED” databases), I could not find any reference to the deleted databases. Under the hood, the Maintenance Plan was still trying to backup those deleted databases because when I clicked OK and then hit Save, that Maintenance Plan was refreshed and everything worked just fine.

So always try to find the root cause.

T-SQL to generate backup and restore commands

Posted by cviorel on August 29, 2014 No comments | This post has 667 views.

Hi guys,

Since my day to day job is a DBA, I figured I will share stuff that others might find useful.
For the first time I will share a small script which will help you generate T-SQL commands in order to script the backup/restore process of your SQL Server.

This was tested on Microsoft SQL Server 2012 (SP1) – Express Edition (64-bit). Feel free to send your comments.

/*

This script will list all the databases on the server and generate backup and restore commands for each database, based on the recovery model.
The script will also determine if your SQL Server version supports compressed backups and will generate the commands accordingly.

(C) viorel.ciucu@gmail.com, 28 Aug 2014

*/

DECLARE @backup_location VARCHAR(254) = 'C:\TEMP\' -- full, UNC path
DECLARE @compresion VARCHAR(13) = ''
DECLARE @a nvarchar(max) = ''

DECLARE @CR AS CHAR(1)    -- Carriage Return (CR)
DECLARE @LF AS CHAR(1)    -- Line Feed (LF)
DECLARE @CrLf AS CHAR(2)  -- Carriage Return / Line Feed

SET @CR = CHAR(10)
SET @LF = CHAR(13)
SET @CrLf = @CR + @LF

IF (SERVERPROPERTY('EngineEdition') = 3)
	BEGIN
		PRINT 'Enterprise Edition detected, backup compression IS SUPPORTED!';
		SET @compresion = ' ,COMPRESSION';
	END
ELSE
	BEGIN
		PRINT 'Enterprise Edition NOT detected, backup compression IS NOT SUPPORTED!';
		SET @compresion = '';
	END


SELECT @@SERVERNAME as ServerName, database_id, name, --recovery_model, recovery_model_desc,
--CONCAT('ALTER DATABASE  [', name, '] SET READ_ONLY') AS read_only_command,
CONCAT('BACKUP DATABASE [', name, '] TO DISK = N''', @backup_location+name, '.bak''', ' WITH NOFORMAT, NOINIT', @compresion, ', STATS = 10;') +  @CR +
CASE WHEN recovery_model in (1, 2) -- the recovery model is either FULL or BULK_LOGGED
THEN
	CONCAT('BACKUP LOG  [', name, '] TO DISK = N''', @backup_location+name, '.trn'' WITH NOFORMAT, NOINIT, STATS = 10') + @LF
ELSE
	''
END AS backup_command, 
--CONCAT('ALTER DATABASE  [', name, '] SET  READ_WRITE WITH NO_WAIT') AS read_write_command,
CONCAT('RESTORE DATABASE [', name, '] FROM DISK = N''', @backup_location+name, '.bak''', ' WITH REPLACE, NORECOVERY;') +  @CR +
CASE WHEN recovery_model in (1, 2) -- the recovery model is either FULL or BULK_LOGGED
THEN
	CONCAT('RESTORE LOG [', name, '] FROM DISK = N''', @backup_location+name, '.trn''', ' WITH NORECOVERY;') + @LF +
	CONCAT('RESTORE DATABASE [', name, '] WITH RECOVERY;') + @LF
ELSE
	CONCAT('RESTORE DATABASE [', name, '] WITH RECOVERY;') + @LF
END AS restore_command
FROM sys.databases WITH (NOLOCK) WHERE database_id > 4
ORDER BY name

This script will list all the databases on the server and generate backup and restore commands for each database, based on the recovery model.

The script will also determine if your SQL Server version supports compressed backups and will generate the commands accordingly.

DECLARE @backup_location VARCHAR(254) = 'C:\TEMP\' -- full, UNC path

DECLARE @compresion VARCHAR(13) = ''

DECLARE @a nvarchar(max) = ''

DECLARE @CR AS CHAR(1) -- Carriage Return (CR)

DECLARE @LF AS CHAR(1) -- Line Feed (LF)

DECLARE @CrLf AS CHAR(2) -- Carriage Return / Line Feed

SET @CR = CHAR(10)

SET @LF = CHAR(13)

SET @CrLf = @CR + @LF

IF (SERVERPROPERTY('EngineEdition') = 3)

BEGIN

PRINT 'Enterprise Edition detected, backup compression IS SUPPORTED!';

SET @compresion = ' ,COMPRESSION';

END

ELSE

BEGIN

PRINT 'Enterprise Edition NOT detected, backup compression IS NOT SUPPORTED!';

SET @compresion = '';

END

SELECT @@SERVERNAME as ServerName, database_id, name, --recovery_model, recovery_model_desc,

--CONCAT('ALTER DATABASE [', name, '] SET READ_ONLY') AS read_only_command,

CONCAT('BACKUP DATABASE [', name, '] TO DISK = N''', @backup_location+name, '.bak''', ' WITH NOFORMAT, NOINIT', @compresion, ', STATS = 10;') + @CR +

CASE WHEN recovery_model in (1, 2) -- the recovery model is either FULL or BULK_LOGGED

THEN

CONCAT('BACKUP LOG [', name, '] TO DISK = N''', @backup_location+name, '.trn'' WITH NOFORMAT, NOINIT, STATS = 10') + @LF

ELSE

END AS backup_command,

--CONCAT('ALTER DATABASE [', name, '] SET READ_WRITE WITH NO_WAIT') AS read_write_command,

CONCAT('RESTORE DATABASE [', name, '] FROM DISK = N''', @backup_location+name, '.bak''', ' WITH REPLACE, NORECOVERY;') + @CR +

CASE WHEN recovery_model in (1, 2) -- the recovery model is either FULL or BULK_LOGGED

THEN

CONCAT('RESTORE LOG [', name, '] FROM DISK = N''', @backup_location+name, '.trn''', ' WITH NORECOVERY;') + @LF +

CONCAT('RESTORE DATABASE [', name, '] WITH RECOVERY;') + @LF

ELSE

CONCAT('RESTORE DATABASE [', name, '] WITH RECOVERY;') + @LF

END AS restore_command

FROM sys.databases WITH (NOLOCK) WHERE database_id > 4

ORDER BY name

DriveDroid

Posted by cviorel on June 23, 2014 No comments | This post has 617 views.

DriveDroid is an Android application that allows you to boot your PC from ISO/IMG files stored on your phone.
Install it on your android phone and use it to boot any computer.
You can store any number of ISO/IMG files on your SD card.
Nice!

Disable recent documents in Gtk2/Gtk3

Posted by cviorel on March 7, 2012 No comments | This post has 575 views.

Use the following to disable recent documents in Gtk2/Gtk3:

echo 'gtk-recent-files-max-age=0' | tee -a $HOME/.gtkrc-2.0
echo 'gtk-recent-files-max-age=0' | tee -a $HOME/.config/gtk-3.0/settings.ini

1 2	echo 'gtk-recent-files-max-age=0' \| tee -a $HOME/.gtkrc-2.0 echo 'gtk-recent-files-max-age=0' \| tee -a $HOME/.config/gtk-3.0/settings.ini

The ugly part is that there is no way one can disable ‘Recently Used’ in the GtkFileChooser dialog box.

Quick way to convert Mbox mailboxes to Maildir format

Posted by cviorel on December 17, 2011 No comments | This post has 642 views.

A quick way to convert Mbox mailboxes to Mbox format is to use mb2md.
Install it in Ubuntu/Debian using:

sudo aptitude install mb2md

1	sudo aptitude install mb2md

To make the convertion use:

mb2md -m

mb2md -m

From man:

       -m        If this is used then the source will be the single mailbox at /var/spool/mail/blah for user blah and the destination mail‐
                 box will be the "destdir" mailbox itself.

1 2	-m If this is used then the source will be the single mailbox at /var/spool/mail/blah for user blah and the destination mail‐ box will be the "destdir" mailbox itself.

Nice and simple!

Bash script to backup my configs (dotfiles)

Posted by cviorel on June 17, 2011 1 comment | This post has 1,030 views.

I needed some script to take care of my config files and put them in a single directory. So here it is.

#!/bin/bash

# Display All Hidden Dot Files In a Directory
# ls -a | egrep "^\." > backup_dotfiles.sh

DESTINATION="/storage/dotfiles"  # do not use a trailing slash (/)

# Colors
blue="\e[0;34m"
green="\e[1;32m"
red="\e[0;31m"
bold="\e[1;30m"
reset="\e[0m"

# file list (use trailing slash for directories)
FILES="
.bash_aliases
.bash_logout
.bash_profile
.bashrc
.colours/
.config/openbox/
.config/terminator/
.config/tint2/
.config/zathura/
.devilspie/
.fehbg
.fonts.conf
.gtk-bookmarks
.gtkrc-2.0
.gtkrc-2.0.mine
.inputrc
.mplayer/
.nanorc
.rtorrent.rc
.screenrc
.synergy.conf
.vim/colors/
.vimrc
.xbindkeysrc
.Xdefaults
.xinitrc
.xmod
.Xmodmap
.xsession
.xxkb/
.xxkbrc
"
for file in $FILES
do
   if [ -d $file ]; then
      mkdir -p $DESTINATION/$file
      cp -f $HOME/$file* $DESTINATION/$file
   elif [ -f $file ]; then
      cp -f $HOME/$file $DESTINATION
   else
      echo -e "$red:: $file is not a file/directory! $reset"
   fi     
done

echo -e "$green:: Done! $reset"
exit 0

#!/bin/bash

# Display All Hidden Dot Files In a Directory

# ls -a | egrep "^\." > backup_dotfiles.sh

DESTINATION="/storage/dotfiles" # do not use a trailing slash (/)

# Colors

blue="\e[0;34m"

green="\e[1;32m"

red="\e[0;31m"

bold="\e[1;30m"

reset="\e[0m"

# file list (use trailing slash for directories)

FILES="

.bash_aliases

.bash_logout

.bash_profile

.bashrc

.colours/

.config/openbox/

.config/terminator/

.config/tint2/

.config/zathura/

.devilspie/

.fehbg

.fonts.conf

.gtk-bookmarks

.gtkrc-2.0

.gtkrc-2.0.mine

.inputrc

.mplayer/

.nanorc

.rtorrent.rc

.screenrc

.synergy.conf

.vim/colors/

.vimrc

.xbindkeysrc

.Xdefaults

.xinitrc

.xmod

.Xmodmap

.xsession

.xxkb/

.xxkbrc

for file in $FILES

if [ -d $file ]; then

mkdir -p $DESTINATION/$file

cp -f $HOME/$file* $DESTINATION/$file

elif [ -f $file ]; then

cp -f $HOME/$file $DESTINATION

else

echo -e "$red:: $file is not a file/directory! $reset"

done

echo -e "$green:: Done! $reset"

exit 0

Moved to ArchLinux!

Posted by cviorel on June 16, 2011 No comments | This post has 1,049 views.

Moved my ThinkPad T61 to ArchLinux! (Still using Ubuntu on many other machines.)

Screenshot:

I will post some install script I used to configure my system.

Liferea custom stylesheet

Posted by cviorel on June 16, 2011 1 comment | This post has 765 views.

I don’t like very much the default font used by Liferea, so I decided to use my custom font. Here is how:
1. Copy the default stylesheet to liferea folder in my $HOME:

cp /usr/share/liferea/css/liferea.css $HOME/.liferea_1.6

1	cp /usr/share/liferea/css/liferea.css $HOME/.liferea_1.6

2. Add this:

{
	font-family: Aurulent Sans;
}

{

font-family: Aurulent Sans;

}

at the begining of liferea.css file.

This is how it looks now:

Of course, you can also play with all the other options in the liferea.css.
Have fun!

Ubuntu Kindle eBooks

Posted by cviorel on March 21, 2011 No comments | This post has 521 views.

Need some great Ubuntu eBooks to read on your Kindle? Look no further. Keir Thomas has some excellent guides for you.

Beautify SQL code

Posted by cviorel on March 15, 2011 No comments | This post has 570 views.

Recently I had the oportunity to test SQL Pretty Printer (Add-In for SSMS). I don’t have to waste time formatting long sql queries. In no time, SQL Pretty Printer does the job
for me. It can also translate the sql code into C#, Java, Php and many other program languages so I can use it in my own programs.
SQL Pretty printer is designed to deal with SQL statement used by different Database Such as MSSQL, Oracle, DB2, Informix, Sybase, Postgres, MySQL and so on. The code conforms to most of the entry-level SQL99 Standard.
To use this add-in you need to have SQL Server Management Studio (SSMS), with .NET2.0 installed. In sql editor you can use shortcut key (ctrl+k,ctrl+j for all sqls, and ctrl+k, ctrl+h for selected sql). There is also a toolbar with two buttons to format sql or selected sql.
To see it in action, take a look here, where you have some sample code blocks before and after the formatting.

Page 3 of 12
<
1
2
3
4
5
6
7
8
9
10
...
12
>

cviorel.com

Author Archives: cviorel - Page 3

DTExec: The package execution returned DTSER_FAILURE (1)

T-SQL to generate backup and restore commands

DriveDroid

Disable recent documents in Gtk2/Gtk3

Quick way to convert Mbox mailboxes to Maildir format

Bash script to backup my configs (dotfiles)

Moved to ArchLinux!

Liferea custom stylesheet

Ubuntu Kindle eBooks

Beautify SQL code

Categories

Author Archives: cviorel - Page 3

Social

Categories

Tags