Server Configuration

Create Account
I like to be a member. Claire wrote: Location of .tuf file in log shipping 21-Feb-07 We are using SQLServer 2005 and setting up log shipping with a Primary, Secondary and Monitor server. When I go thru' the setup of log shipping and let SQLServer backup and restore my database, it insists on trying to ... 30 Dec 2009 12:03

Log Shipping shrink the secondary server.
I have configured a log shipping setup, unfortunately I did not shrink the log file before taking the backup on the primary server. Now I realized that the log file on the secondary server is really big. The DB has been configure to be in standby & redonly mode... Can I shrink the secondary databases log file .. ... 30 Dec 2009 12:03

OLE DB provider "SQLNCLI10" for linked server "XXXXXX" returned message"The stored procedure required to complete this operation could not be found onthe server. Please contact your system administrator.".
I have the same problem. I resolved with this: Here is the text of the proc in case you ever need to do the same, create it in the master database: create procedure sp_tables_info_rowset_64 @table_name sysname, @table_schema sysname = null, @table_type nvarchar(255) = null ... 28 Dec 2009 20:43

Shrink on Log Shipping process
Hello all!, my question is the following: is it possible to shrink the log file in a log shipping scenario?. Thanks very much, Juanma. ... 28 Dec 2009 06:23

VWware Cannot SQL Server Database Engine cannot obtain LOCK
Please help me resolve the SQL Server error listed below from VMware Server accessing SQL Server. Thanks, The description for Event ID ( 1000 ) in Source ( VMware VirtualCenter Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display me... 27 Dec 2009 14:08

windows 7
I can't get windows 7 until I get ".NET Framework 2.0 ". in my computer. error 25015 and 0x80131107. ... 26 Dec 2009 17:41

error 25015 and 0x80121107
I am trying to get .NET Framework 2.0 in my computer so I can get Windows 7. ... 26 Dec 2009 14:23

sql server 2005 triggers
I have one variable (ex. @var). I want to create table with the table name contained in the variable. How I can? ... 24 Dec 2009 10:47

SQL 2005 express database monitoring
Can someone advise how to monitor SQL 2005 express database size? Thank you very much! ... 24 Dec 2009 05:21

Trouble with KB 970315
I have a clustered SQL 2008 SP 1 running on Win2k3 R2 x64 SP2. There are two DB instances, the default for SharePoint, vcenter, and some custom databases and the other for OCS. I applied the cumulative update of KB 970315 to one of the nodes so that I could use the server for SharePoint 2010 beta 2. Before a... 29 Dec 2009 11:56