Logshipping help

As part of my effort to create my own log shipping method, i'm reading
the
documentation people have suggested here. I'm not familiar with some
concepts, the following in particular. From the website
(http://www.sql-server-performance.co...g_shipping.asp
I do have a backup device called DEV_device and the complete path is
D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
The article contains the statement below which I am not sure I
completely understand...
RESTORE LOG database_name
FROM DISK = 'g:\mssql7\backup\log\database_name\database_name_ log_backup_device.bak'
The device name in the Authors scenario is
database_name_log_backup_device
My understanding is that a device encompasses the whole path not a
subset of the path(like above).Tested this with little success and my
hope is that there is some one out here with a better understanding
than myself to help out
TIA
TY
TY,
The two flavors of BACKUP/RESTORE concerning how to address your file/tape are:
BACKUP...
FROM DISK = 'C:\...'
BACKUP...
FROM logical_device_name
In the first example, you address the physical file. No backup devices are needed.
A backup device is like a pointer to a physical file. These are the ones you see in the backup
folder in Enterprise Manager. If you want to address the file using a backup device, use the second
alternative.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tyler Smith Watu" <watuni2000@.yahoo.co.nz> wrote in message
news:2f3438a4.0410120431.386cd44f@.posting.google.c om...
> As part of my effort to create my own log shipping method, i'm reading
> the
> documentation people have suggested here. I'm not familiar with some
> concepts, the following in particular. From the website
> (http://www.sql-server-performance.co...g_shipping.asp
> I do have a backup device called DEV_device and the complete path is
> D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
>
> The article contains the statement below which I am not sure I
> completely understand...
> RESTORE LOG database_name
> FROM DISK = 'g:\mssql7\backup\log\database_name\database_name_ log_backup_device.bak'
> The device name in the Authors scenario is
> database_name_log_backup_device
>
> My understanding is that a device encompasses the whole path not a
> subset of the path(like above).Tested this with little success and my
> hope is that there is some one out here with a better understanding
> than myself to help out
>
> TIA
> TY

Logshipping help

As part of my effort to create my own log shipping method, i'm reading
the
documentation people have suggested here. I'm not familiar with some
concepts, the following in particular. From the website
(http://www.sql-server-performance.com/sql_server_log_shipping.asp
I do have a backup device called DEV_device and the complete path is
D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
The article contains the statement below which I am not sure I
completely understand...
RESTORE LOG database_name
FROM DISK = 'g:\mssql7\backup\log\database_name\database_name_log_backup_device.bak'
The device name in the Authors scenario is
database_name_log_backup_device
My understanding is that a device encompasses the whole path not a
subset of the path(like above).Tested this with little success and my
hope is that there is some one out here with a better understanding
than myself to help out
TIA
TYTY,
The two flavors of BACKUP/RESTORE concerning how to address your file/tape are:
BACKUP...
FROM DISK = 'C:\...'
BACKUP...
FROM logical_device_name
In the first example, you address the physical file. No backup devices are needed.
A backup device is like a pointer to a physical file. These are the ones you see in the backup
folder in Enterprise Manager. If you want to address the file using a backup device, use the second
alternative.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tyler Smith Watu" <watuni2000@.yahoo.co.nz> wrote in message
news:2f3438a4.0410120431.386cd44f@.posting.google.com...
> As part of my effort to create my own log shipping method, i'm reading
> the
> documentation people have suggested here. I'm not familiar with some
> concepts, the following in particular. From the website
> (http://www.sql-server-performance.com/sql_server_log_shipping.asp
> I do have a backup device called DEV_device and the complete path is
> D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
>
> The article contains the statement below which I am not sure I
> completely understand...
> RESTORE LOG database_name
> FROM DISK = 'g:\mssql7\backup\log\database_name\database_name_log_backup_device.bak'
> The device name in the Authors scenario is
> database_name_log_backup_device
>
> My understanding is that a device encompasses the whole path not a
> subset of the path(like above).Tested this with little success and my
> hope is that there is some one out here with a better understanding
> than myself to help out
>
> TIA
> TY

Logshipping help

As part of my effort to create my own log shipping method, i'm reading
the
documentation people have suggested here. I'm not familiar with some
concepts, the following in particular. From the website
(http://www.sql-server-performance.c...og_shipping.asp
I do have a backup device called DEV_device and the complete path is
D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
The article contains the statement below which I am not sure I
completely understand...
RESTORE LOG database_name
FROM DISK = 'g:\mssql7\backup\log\database_name\data
base_name_log_backup_dev
ice.bak'
The device name in the Authors scenario is
database_name_log_backup_device
My understanding is that a device encompasses the whole path not a
subset of the path(like above).Tested this with little success and my
hope is that there is some one out here with a better understanding
than myself to help out
TIA
TYTY,
The two flavors of BACKUP/RESTORE concerning how to address your file/tape a
re:
BACKUP...
FROM DISK = 'C:\...'
BACKUP...
FROM logical_device_name
In the first example, you address the physical file. No backup devices are n
eeded.
A backup device is like a pointer to a physical file. These are the ones you
see in the backup
folder in Enterprise Manager. If you want to address the file using a backup
device, use the second
alternative.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tyler Smith Watu" <watuni2000@.yahoo.co.nz> wrote in message
news:2f3438a4.0410120431.386cd44f@.posting.google.com...
> As part of my effort to create my own log shipping method, i'm reading
> the
> documentation people have suggested here. I'm not familiar with some
> concepts, the following in particular. From the website
> (http://www.sql-server-performance.c...og_shipping.asp
> I do have a backup device called DEV_device and the complete path is
> D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
>
> The article contains the statement below which I am not sure I
> completely understand...
> RESTORE LOG database_name
> FROM DISK = 'g:\mssql7\backup\log\database_name\data
base_name_log_backup_d
evice.bak'
> The device name in the Authors scenario is
> database_name_log_backup_device
>
> My understanding is that a device encompasses the whole path not a
> subset of the path(like above).Tested this with little success and my
> hope is that there is some one out here with a better understanding
> than myself to help out
>
> TIA
> TY

Login Page

Hi,

i created my own table.it includes usr_name,usr_surname,usr_email,usr_password

and i have login form.it includes 2 texboxes.1 for login(email) and the other for password.How can i query the user on database if user on db and his password matches with his username.dont advice me to try asp.net membership please..i want to create my own.i am using sql,asp.net codebehind:vb.
if you give example with stored procedure it can be more useful for me.

thanks,

create procedure [dbo].[login_verify](@.user varchar(30),@.pwd varchar(20),@.msg varchar(30)
out) as
select @.user=username,@.pwd=password from users where username=@.user and
password=@.pwd
if @.@.rowcount=0
set @.msg='Invalid User or Pasword'
else
set @.msg='Hello world'

or

in aspx page

Function login_verify(ByVal user As String, ByVal pwd As String) As Boolean
con = New SqlConnection
con.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
st = "select username,password from users where username =" & "'" & user & "'" & " and password= " & "'" & pwd & "'"
cmd = New SqlCommand(st, con)
Try
con.Open()
dr = cmd.ExecuteReader
dr.Read()
If dr(0) = user And dr(1) = pwd Then Return True Else Return False
Catch ex As Exception
Response.Write("Invalid Login or Password")
End Try
con.Close()
End Function

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

|||

Hi there,

take a look at this article I think it can be helpful.

http://support.microsoft.com/kb/910440

Regards,

Fernando

|||

thnx