[MSSQL7] Backup on network drive

Hi there,
Does anyone know if it's possible to perform a MSSQL7 database backup on a network drive instead of the local drives ?
...and if yes, how to proceed ?
It seems to be possible under MSSQL2000.
Many thanks for your help in advance,
MattEach MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule|||many thanks for this answer ;o)|||Originally posted by fadace
Each MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule

It is not a true:

backup DATABASE database
to disk ='\\networkserver\BACKUP\database.bak'|||hu interresting, gonna have a try with this !! thanks !! :)

is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.|||Originally posted by mattoo
hu interresting, gonna have a try with this !! thanks !! :)

is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.

If someone cuts a network cable it should be a problem but no more.|||Fine. Many thanks again for your help ;)

[LOG] Unable to read local eventlog (reason: The parameter is incorrect) - FLOOD

[LOG] Unable to read local eventlog (reason: The parameter is incorrect)

I just had two seperate SQL Server 2005 Enterprise Edition machines suddently throw thousands of these errors within the last 24 hours. In both cases the the SQL agent and application event logs are just being flooded with a new entry every couple of seconds.

While the errors are being logged the Agent continues to run jobs (e.g. scheduled backups, etc.) without error.

A restart of the agent stops the errors and everything seems to be back to normal.

There is no commonality between the two machines, they are on different networks, domains, etc.

Both machines have been up >30 days and have not previously logged this error.

Anybody else seen this?

Thanks,

Joe

See this post Joe:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124086&SiteID=1

HTH,

[HELP] LTM Problem

who can help me with LTM(Local Test Manager), many thanks.
Output as follow-------------------------------
Suite: DefaultSuite StartTime: Mon Oct 13 09:54:51 2003 Version: 02.60.6720.0
-------------------------------
Alias: SQLSv Clsid: SQLOLEDB Version: 08.50.1022.00
Initialization: file=c:\adosql.ini
Context: CLSCTX_INPROC_SERVER
Client: Machine: MINGLEI Processor: Intel System: Windows 2000 Version: 5.0 Build: 2195 Service Pack 4 ThreadingModel: Single

Module: ADO Level 0 Conformance Tests Desc: ADO Provider Tests - Level 0 Version: 01.00.0000.04
TestCase: cn.Close Desc: Connection Close Tests
Variation (1) Open Connection, Close Connection
*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = -2147467259
DESC = Invalid authorization specification
Source = Microsoft OLE DB Provider for SQL Server

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = -2147467259
DESC = Invalid authorization specification
Source = Microsoft OLE DB Provider for SQL Server

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

FAILED
Variation (2) Close Connection before opening
PASSED
TestCase: cn.Execute Desc: Connection Execute Tests
Variation (1) Execute valid command string
*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = -2147467259
DESC = Invalid authorization specification
Source = Microsoft OLE DB Provider for SQL Server

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Recordset

*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

FAILED
Variation (2) Execute zero length string
*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = -2147467259
DESC = Invalid authorization specification
Source = Microsoft OLE DB Provider for SQL Server

*** FAILED ***

EXPECTED ERROR = -2147217908
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

*** FAILED ***

EXPECTED ERROR = -2147217908
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

FAILED
TestCase: cn.Open Desc: Connection Open Tests
Variation (1) Open connection, check for property count increase
*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = -2147467259
DESC = Invalid authorization specification
Source = Microsoft OLE DB Provider for SQL Server

Property count did not increase after open
*** FAILED ***

NO ERROR EXPECTED
ACTUAL ERROR = 3704
DESC = Operation is not allowed when the object is closed.
Source = ADODB.Connection

FAILED
Summary: Failures: 4 Warnings: 0 Skipped: 0 Passed: 1 Run: 5 Percent: 20
-------------------------------
SuiteEnd: DefaultSuite Status: Complete StopTime: Mon Oct 13 09:54:51 2003
Fail Warn Skip Pass Percent Alias Module
4 0 0 1/ 5 20% SQLSv ADO Level 0 Conformance Tests
-------------------------------Invalid authorization specification
Sounds like an error in the connection string.
Maybe the string is invalid or maybe the server isn't set up to allow sql server authyentication and it is using that.|||thanks, but every settings is by default, what can I do then ?

@local variable (newbie)

I am trying to run a query.

Declare ColNames_Csr Cursor
-- Open Cursor that contains all column names
for
Select Column_Name from Information_Schema.columns where Table_Name = @.TableName

Open ColNames_csr

Fetch Next From ColNames_csr into @.FieldName

While ...

Begin
.
.
.
Select @.FieldValue = (Select @.FieldName from Contacts)
Print @.FieldValue
.
.
.
end

@.SomeValue always returns the FieldName (EMail) not @.FieldName (name@.somewhere.com).

I am trying to roll through all the columns and see what the value is for @.fieldname

What am i missing?

Thanks
LJOriginally posted by LittleJonny
I am trying to run a query.

Declare ColNames_Csr Cursor
-- Open Cursor that contains all column names
for
Select Column_Name from Information_Schema.columns where Table_Name = @.TableName

Open ColNames_csr

Fetch Next From ColNames_csr into @.FieldName

While ...

Begin
.
.
.
Select @.FieldValue = (Select @.FieldName from Contacts)
Print @.FieldValue
.
.
.
end

@.SomeValue always returns the FieldName (EMail) not @.FieldName (name@.somewhere.com).

I am trying to roll through all the columns and see what the value is for @.fieldname

What am i missing?

Thanks
LJ

Query below returns value of @.FieldName - no field in table. Think about dynamic query ...

(Select @.FieldName from Contacts)|||Dynamic Query? Im not sure I understand.

@.FieldName = 'Name'

Select @.FieldValue = (Select @.FieldName from Contacts where contactid = 32)

Print @.FieldValue

Always Prinst "Name"

How do I get the data in Contacts.@.FieldName?

Thanks
LJ|||Originally posted by LittleJonny
Dynamic Query? Im not sure I understand.

@.FieldName = 'Name'

Select @.FieldValue = (Select @.FieldName from Contacts where contactid = 32)

Print @.FieldValue

Always Prinst "Name"

How do I get the data in Contacts.@.FieldName?

Thanks
LJ

Dynamic query is something like this:

create table test(id int, code varchar(10))
go
insert test values(1,'A')
insert test values(2,'B')
insert test values(3,'C')
go
create proc retvalue(@.sql varchar(8000),@.result varchar(50) output)
as
declare @.res varchar(50)
create table #tmp(res varchar(50))
insert #tmp exec(@.sql)
select @.result=res from #tmp
return
go
declare @.res varchar(50),@.sql varchar(8000),@.field varchar(50)
set @.field='code'
set @.sql='select '+@.field+' from test'
exec retvalue @.sql,@.res output
select @.res