i want to know what are the advantages of transaction log backup in sql server 2008?
View Complete Post
I know how to take total database backup in SQL server 2008 and SQL Server Management Studio Environment but i failed to take single table backup in database.
It is possible to take single table backup in Oracle using PL/SQL Developer IDE.
Thanks in Advance.....
Hi. I have had an issue trying to get distributed transactions to work in SQL Server 2008 using a linked server. The error message I get is
OLE DB provider "SQLNCLI10" for linked server "pod1" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "pod1" was unable to begin a distributed transaction.
Windows Server 2008 Enterprise 64 bit, SQL Server 2008 Enterprise 64 bit
Problem occurs with multiple different builds of SQL Server 2008 - I have been able to reproduce the problem with 10.0.1600.0, 10.0.1779.0 (CU 2), as well as 10.0.2531 (SP1)
I am aware that other people have had this issue and have reviewed all existing posts. I have verified that the MSDTC is configured correctly on both machines. I have also used DTCTester to verify that DTC is working correctly on all machines in question.
None of the mentioned resolutions has solved this problem for me.
I am not seeing this problem occur on my 32 bit test machines - it is only occurring if at least one of the two machines is 64 bit.
Recently I've been involved in an upgrade project migrating databases from 2000 into 2005; the database then replicates to another company into a 2008 Database. The processes involved extract data from an Oracle database into the 2005 Database
and then transferring the data to the 2008 Database. a Stored procedeure is then fired on both Servers to integrate the extracted/migrated data into the existing data.
The problem is that now we are getting duplicate data in the 2008 database; essentially the Stored Procedure is supposed to delete existing data if it has been migrated and then replace it with the existing data but it appears as though this isn't happening.
Is anybody aware of any issues surrounding 2008 R2 that could explain this?
I used SQL Server 2005 before and used "DUMP TRANSACTION ... WITH NO_LOG" statement, i tried to do sameÃÂ thing in SQL Server 2008 and it doesn't work. How can i use it in SQL Server 2008?
With SQL Server 2000, I can use following T-SQL to clean log:
Backup Log MyDB with truncate_only
ackup Log MyDB with no_log
but when I use it for SQL Server 2008, I got following error:
Msg 3032, Level 16, State 2, Line 1
One or more of the options (no_log) are not supported for this statement. Review the documentation for supported options.
Msg 155, Level 15, State 1, Line 2
'truncate_only' is not a recognized BACKUP option.
so how to resolve this problem?
i have two systems(system A,system B) connected in network and with sql server 2008 installed on both.
i want to take backup of database in system B, using sql server agent in system A..
please help me...
I have upgraded my Sql server 2005 to Sql server 2008 in window 2003 server (SP 2 standard edition) . After upgrading iam getting above mentioned MSDTC issue when try to make an distributed transaction with Sql server 2008 in my .Net
Note: No issues with SQL server 2005...
Please give me an solution
I have SQL Server 2008 r2 clusterd physically on two server.
I have installed a netbackup server on another server physically.
I have installed netbackup client on the two SQL Server nodes.
My Question is how to configure the netclient on the two nodes.??
Can anyone help me please.
The Below codes working fine while I create backup on SQL Server installed on same system. But When I try to take backup on Network, the backup says failure.
Really i can't understand. Just i changed the IP & I tried, but I get failure reply.
For that Any Ideas will be welcome.
MyDTBaseName = "Supplier_Accounts"
MyBckPth = "\\Unc_Path\Year_End_2010"
PurDbName = MyBckPth + "\Sup_SQLSMO.bak"
Dim MyServIp As String = "122.268.2.40, 2745"
Dim MyRemot_ServIp As String = "122.268.2.50, 2745"
Dim MyBackup As Microsoft.SqlServer.Management.Smo.Backup = New Microsoft.SqlServer.Management.Smo.Backup
Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server
'Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server("122.268.2.40,2745")
MyServer.ConnectionContext.ServerInstance = MyServIp
MyServer.ConnectionContext.LoginSecure = False
MyServer.ConnectionContext.Login = "sa"
MyServer.ConnectionContext.Password = "123"
MyBackup.Action = BackupActionType.Database
MyBackup.Database = "Supplier_Accounts"
MyBackup.Devices.Add(New BackupDeviceItem(PurDbName, DeviceType.Fi
To do database backup with C# I am using the following code:
Server myServer = new Server(new Microsoft.SqlServer.Management.Common.ServerConnection(lServer, lUserID, lPassword)); Microsoft.SqlServer.Management.Smo.Backup oBackup = new Microsoft.SqlServer.Management.Smo.Backup(); oBackup.Action = BackupActionType.Database; oBackup.Database = lDatabase; oBackup.Devices.Add(new BackupDeviceItem(mBackupFileName, DeviceType.File)); oBackup.Initialize = true; oBackup.Checksum = true; oBackup.ContinueAfterError = true; oBackup.Incremental = false; oBackup.LogTruncation = BackupTruncateLogType.Truncate; &
Can some one please take a look into this :
EVENT ID :57860
An error occurred while attempting to log in to the following server: "VH01". SQL error number: "0011". SQL error message: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does not exist or access denied. ". For more information, click the following link:
The link shows solution but i do not want to diable my SQL server Agent.Does anyone know why it is occurin