Using INIT Or NOINIT With Backups

Dec 1, 2000

My question is concerning whether or not to use INIT or NOINIT with RETAINDAYS. I know that if the backup has not expired, the backup will fail if you use INIT. But will the backups write over expired backups using the NOINIT or will they just keep appending to the end of the file? Also is there a way to view a backup and find the expiration date? I have looked in Enterprise manager and havent found it. One last question, can you only have backups expire using days? Or can you set the expirations to be a smaller value? Thanks in advance for any help.

View 1 Replies

How About Backup With Init + Zip In One Step?

Jul 3, 2003

For a daily backup job,

Is there a way to "Backup Datbase dbXYZ to backup_dbXYZ with init", go, then next statment of master..xp_cmdshell to zip the backup_dbXYZ.bak to backup_dbXYZ.zip file?

Also, this may need to be done via remote server..

thanks
David

View 8 Replies View Related

TDSSNIClient Init Failure

Feb 21, 2007

I started getting this error when I tried to start my local SQL Server yesterday and nothing I do seems to help:

Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x2, status code 0x35.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x2, status code 0x1.
Error: 17826, Severity: 18, State: 3.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
Error: 17120, Severity: 16, State: 1.
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

The only thing I did recently was move the My Documents folder from my local machine to a folder on a network share (to make sure my docs are backed up) via a right click on the My Documents folder in the Start menu, then pick the new location. I've since moved it back, but the above error persists.

Also, when I try to configure the server's protocols, I'm not able to enable any of the protocols. I can right click the protocol and click enable, then I get the error that says it'll take effect when i restart the service, but then in the display, it still says disabled. Refreshing doesn't change the status. The client protocols are enabled though.

Any help would be greatly appreciated (since the service never successfully starts)...

View 8 Replies View Related

Maintenance Plan --&> Backup --&> With Init?

Dec 10, 2003

Good morning.

We are running SQL Server 2000 with SP3. I have recently created a DB Maintenance Plan to backup all of our databases nightly to a local tape drive, and verify the backup of those databases. The backup plan itself runs fine.

The first time it ran, it ran in a little over an hour. Since then, I have noticed the time increasing nightly to the point that last night's backup took 8 hours. Our databases are not that big and do not have enough transactions to cause such a drastic change in a matter of weeks.

Investigating the problem, I have found that the issue lies in the fact that the tape is not initializing each night, and thus each night's backup is appending to an increasingly more full tape.

My question is this: Is there a way to force a DB Maintenance Plan to initialize the tape each night? I know that I can probably add a "with init" command to the T-SQL statement created, but I am not sure exactly where to fit it in. Does anyone have any suggestions?

Thank you for your time.

Michael

View 1 Replies View Related

Setup Init Error When Installing SQL Server 2k Enterprise, Plz Help

Feb 12, 2004

hi,

i'm running win2k sp4 on a 2.4Ghz P4 with 512M ram and 1.5 gigs freespace on my harddrive (more than enough for the sql server client).

i insert the cd and start up the installer. i then get the splash screen, click on "SQL Server 2000 Components", then on "Install Database Server". Then the splash screen disappears and nothing happens for a while (sometimes a really long while). Then an error message pops up saying:

Setup initialization error.
<some message>

Source: 'E:<some source>'
Target: 'C:WINNTTEMPSqlSetup<some target>'

where <some message> is a differing message. sometimes it's "The data is invalid", sometimes a cycle redundancy check error, sometimes a inpage error...

<some source> is one of the files on the sql server cd, and this also differs most of the time.
<some target> is the corresponding <some source> in the sql server setup's temp dir.

as well, if i restart my computer and try starting the installer after windows has started up (well, at least all of the sys tray icons have loaded) i usually get an error message saying something about "msetup" having an error and being shut down. it also mentions that there is some log file which is created, but i'm not sure where it's located or what it's called.

i have also noticed that some process called " wowexec.exe" is starts up when the installer does, and keeps running after the installer (setupsql.exe) crashes. i am also unable to end the " wowexec.exe" process and process tree.

i don't think there's anything wrong with the cd, since it looks like it works file on other pc's. any idea what may be wrong?

i would really appreciate any help in fixing this. i really need to get the sql server 2k client installed (particularly the enterprise manager).

tia

View 4 Replies View Related

CREATE AGGREGATE Failed Because Type .. Does Not Conform To UDAGG Specification Due To Method 'Init'

Jul 3, 2007

I am trying to get the CLR user-defined aggregate functions sample working (VB version).

I've saved the sample (from Invoking CLR User-Defined Aggregate Functions ) to a .vb file and compiled it like this:

C:dataVStudioprojectsSQLutilsSQLutils>c:WINDOWSMicrosoft.NETFrameworkv2
.0.50727vbc /t:library /out: SQLutils.dll Class1.vb
Microsoft (R) Visual Basic Compiler versie 8.0.50727.42
voor Microsoft (R) .NET Framework versie 2.0.50727.42
Copyright (c) Microsoft Corporation. Alle rechten voorbehouden.

The SQLutils.dll file is created without warnings or errors.

I've created the assembly

create assembly sqlutildll from 'D:SQLdatadllSQLutils.dll'

and then the function:

CREATE AGGREGATE Concat (@input nvarchar(200)) RETURNS nvarchar(max)

EXTERNAL NAME sqlutildll.Concatenate

and then I got this error:

Msg 6558, Level 16, State 1, Line 1

CREATE AGGREGATE failed because type 'Concatenate' does not conform to UDAGG specification due to method 'Init'.

Msg 6597, Level 16, State 2, Line 1

CREATE AGGREGATE failed.

What is this UDAGG specification ?

How can I make this function working?

The VB code:

Code Snippet

Imports System

Imports System.Data

Imports Microsoft.SqlServer.Server

Imports System.Data.SqlTypes

Imports System.IO

Imports System.Text

<Serializable(), SqlUserDefinedAggregate(Format.UserDefined, IsInvariantToNulls:=True, IsInvariantToDuplicates:=False, IsInvariantToOrder:=False, MaxByteSize:=8000)> <Microsoft.VisualBasic.ComClass()> _

Public Class Concatenate

Implements IBinarySerialize

''' <summary>

''' The variable that holds the intermediate result of the concatenation

''' </summary>

Private intermediateResult As StringBuilder

''' <summary>

''' Initialize the internal data structures

''' </summary>

Public Sub Init()

Me.intermediateResult = New StringBuilder()

End Sub

''' <summary>

''' Accumulate the next value, not if the value is null

''' </summary>

''' <param name="value"></param>

Public Sub Accumulate(ByVal value As SqlString)

If value.IsNull Then

Return

End If

Me.intermediateResult.Append(value.Value).Append(","c)

End Sub

''' <summary>

''' Merge the partially computed aggregate with this aggregate.

''' </summary>

''' <param name="other"></param>

Public Sub Merge(ByVal other As Concatenate)

Me.intermediateResult.Append(other.intermediateResult)

End Sub

''' <summary>

''' Called at the end of aggregation, to return the results of the aggregation.

''' </summary>

''' <returns></returns>

Public Function Terminate() As SqlString

Dim output As String = String.Empty

'delete the trailing comma, if any

If Not (Me.intermediateResult Is Nothing) AndAlso Me.intermediateResult.Length > 0 Then

output = Me.intermediateResult.ToString(0, Me.intermediateResult.Length - 1)

End If

Return New SqlString(output)

End Function

Public Sub Read(ByVal r As BinaryReader) Implements IBinarySerialize.Read

intermediateResult = New StringBuilder(r.ReadString())

End Sub

Public Sub Write(ByVal w As BinaryWriter) Implements IBinarySerialize.Write

w.Write(Me.intermediateResult.ToString())

End Sub

End Class

View 5 Replies View Related

DB Engine :: Will Transaction Log Backups Not Free Up Log During Full Backups

Nov 15, 2015

The space allocated to the Log in question is 180 GB. During this time period I was running TLog backups every 5 minutes, yet the log continued to chew through to 80 GB used, even after the process was complete and a final TLog backup had been taken. It continued to stay very large until the Full backup was complete -- or something else that I'm unaware of completed. Like every other DBA I typically take a TLog backup to shrink the log, but what appeared to be the case here was the Full completed and it released the used log space. All said, will Transaction Log backups not free up the log during Full backups?