nikhil.desai1 (1/15/2012)

---

Msg 7391, Level 16, State 2, Procedure ddltrg_Audit_LOG, Line 89

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "ipaddress" was unable to begin a...

nirnaykhatri (1/12/2012)

---

That means therez isn't possibility of accessing log files without the need of third party tools. What are log files in objectExplorer->Management->Sgl Server log file. Is...

balaji.ganga 68339 (1/12/2012)

---

Thanks for you reply suresh.. I have few questions like

I believe there is no compression backup option from SQL 2000 environment.

Is there any chances to copied...

Knowledge Hunter (1/12/2012)

---

Hi All,

We have a SQL Server 2008 R2 hosted on a server having OS Windows Server 2008 R2.

I am added to Windows, Admin group for the server.

When I...

It looks like the backup file you are trying to copy is big (in GBs) and your DEV server has very less free RAM.

You can try copying compressed backup file....

chaudharydpk0 (1/12/2012)

---

Sir, actually i deleted 5000 rows in my table in sql 2008 r2 but after that the table size in unchanged. I daily need to delete thousand's record in...

You can add a column to the table called Locked with default value N.

When you read it for monitoring, change the column value to Y.

If value is Y, don't...

I know that this post is few weeks older, still responding....

1) Failover the cluster server. This doesn't help becuase same file is used by the nodes.

2) Drive has enough space....

You have not mentioned whether you have monitored the drive space.

Is AutoGrow is ON?

1) You can't shrink file, if 100% file space is utilized

2) If you have free space is...

Try this. May work. Not tested.

Write the instance name inside the sqare...

You may get this info by querying DMOs, if your server is not restarted in the last 6 months.

SKYBVI (1/5/2012)

---

...

If the database is offline and does not start.

Try to take a tail-log backup. Because no transactions can occur at this time, using WITH NORECOVERY is optional. If the...

If a user is member of only db_datareader db role he/she can only select. He/she cannot alter or update.

Check whether alter or update permission is granted separately.

Also check whether...

EXEC sys.sp_configure N'remote access', N'1'

GO

RECONFIGURE WITH OVERRIDE

GO

By default SQL Server does not allow remote connections. You need to enable remote connections.