Viewing 15 posts - 166 through 180 (of 433 total)
What is SQL Server 2005 version? Is it with SP2 and latest update if not plesae go ahead and apply.
>> You can compare both the execution plan and find...
June 8, 2009 at 12:18 am
June 5, 2009 at 4:44 am
What is the size of the backup file? Is SQL Server with SP2?
June 5, 2009 at 4:31 am
May be permission issue. Check if SQL Server startup account have all the permission to write on to the backup folder. OPerating system error 2 :- The system cannot find...
June 5, 2009 at 4:28 am
You can use RESTORE FILELISTONLY which will return list of the database and log files contained in the backup. If your backup have 2 data file and 2 log file...
June 5, 2009 at 4:08 am
At the mean time, data inside Live DB A may be will be updated or deleted while the data is being process in Live DB B..
The changes will be reflected...
May 24, 2009 at 9:48 pm
Bingo !!:-D
I resetup the Transaction Replication with readonly subscribtion and the local users are able to update & insert the data to the subscribtion Database but the changes are not...
May 23, 2009 at 4:53 am
Thanks for reply.
I think updatable subscribtion will propagate updates to the publisher which I dont want. My req. is publisher should updates the subscribtion so that the data are in...
May 22, 2009 at 10:34 pm
THe following steps helped me to solved the issue.:-)
SELECT [name], [log_reuse_wait], [log_reuse_wait_desc]
FROM sys.databases
My result was:
name log_reuse_wait log_reuse_wait_desc
dbname ...
April 6, 2009 at 9:25 am
I had reintilized the replication and but not able to truncate it as it gives file in use error message.
The error message which I had mentioned in the post...
April 3, 2009 at 8:12 am
REPLICATION for the specified DB. I know snapshot replication have been setup.
also dbss sqlperf(logspace) gives me 100 % space used for the same DB.
I dont have disk space. But need...
April 3, 2009 at 7:47 am
Check if the SP3 has been applied successfully or not? You also need to apply the recent patch(CU1).
Check this link this might help you.
March 17, 2009 at 9:45 pm
SQL Server: Memory Manager: Connection Memory (KB) will give an hint of how much memory is getting used by SQL Server will give the information also try using DBCC memorystatus.
January 22, 2009 at 4:15 am
First post it in the right forum. You need to run DBCC CHECKDB command to find out if there is any corruption I mean incosistency in your DB. some time...
January 22, 2009 at 1:56 am
We have decided to take the SQL Server backup to Tapes using Tivoli instead taking the backup location ( Disk) to Tape which was suggested earlier.
Need help in setting...
January 5, 2009 at 10:29 pm
Viewing 15 posts - 166 through 180 (of 433 total)