saeid taheri
یک شنبه 18 مرداد 1388, 12:18 عصر
سلام من زماني كه مي خواهم از بانك اطلاعاتي خود نسخه پشتيبان بگيرم دچار مشكل زير مي شوم
Could not locate entry in sysdatabases for database 'testDB.mdf'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
Could not locate entry in sysdatabases for database 'testDB.mdf'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
كد برنامه
Dim Cnn As SqlConnection = Me.GetConnection
Dim Cmd As New SqlCommand("backUpME", Cnn)
Cmd.CommandType = CommandType.StoredProcedure
Dim param As SqlParameter
param = Cmd.Parameters.Add("@dbName", SqlDbType.NVarChar, 50)
param.Value = db1
param = Cmd.Parameters.Add("@disk", SqlDbType.NVarChar, 300)
param.Value = disk1
Dim Taeid As Boolean = False
Try
Cnn.Open()
Cmd.ExecuteNonQuery()
Taeid = True
Catch ex As Exception
Taeid = False
Finally
If (Cmd IsNot Nothing) Then Cmd.Dispose()
If (Cnn.State <> ConnectionState.Closed) Then Cnn.Close()
End Try
Return Taeid
و
ALTER PROCEDURE dbo.backUpME
(
@dbName Nvarchar(50),
@disk Nvarchar(300)
)
AS
BEGIN
BACKUP DATABASE @dbName TO DISK = @disk with INIT
BACKUP DATABASE @dbName
TO DISK = @disk
END
اگر راهنمايي بفرماييد ممنون مي شم
Could not locate entry in sysdatabases for database 'testDB.mdf'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
Could not locate entry in sysdatabases for database 'testDB.mdf'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
كد برنامه
Dim Cnn As SqlConnection = Me.GetConnection
Dim Cmd As New SqlCommand("backUpME", Cnn)
Cmd.CommandType = CommandType.StoredProcedure
Dim param As SqlParameter
param = Cmd.Parameters.Add("@dbName", SqlDbType.NVarChar, 50)
param.Value = db1
param = Cmd.Parameters.Add("@disk", SqlDbType.NVarChar, 300)
param.Value = disk1
Dim Taeid As Boolean = False
Try
Cnn.Open()
Cmd.ExecuteNonQuery()
Taeid = True
Catch ex As Exception
Taeid = False
Finally
If (Cmd IsNot Nothing) Then Cmd.Dispose()
If (Cnn.State <> ConnectionState.Closed) Then Cnn.Close()
End Try
Return Taeid
و
ALTER PROCEDURE dbo.backUpME
(
@dbName Nvarchar(50),
@disk Nvarchar(300)
)
AS
BEGIN
BACKUP DATABASE @dbName TO DISK = @disk with INIT
BACKUP DATABASE @dbName
TO DISK = @disk
END
اگر راهنمايي بفرماييد ممنون مي شم