Viewing 15 posts - 166 through 180 (of 333 total)
My 2 cents....
1. Its 64 Bit SQL Server?
2. Its HP Box?
3. Its x64 CPU?
If above all are true then follow below two things.
1. Follow KB:
918483 You can enable the lock...
October 7, 2006 at 1:01 am
I would like you to check below enviornment variables
TEMP and TMP
Make sure that they are valid. If possible change them to C:\TEMP for installation.
October 7, 2006 at 12:49 am
October 7, 2006 at 12:27 am
Looks like you are restoring series of backup i.e.
Restoring full backup with no recovery
Below is a small sample
==============
create database ssc
select getdate()
backup database ssc to disk = 'c:\ssc.bak'
select getdate()
backup LOG...
October 7, 2006 at 12:17 am
When you take full backup of the database it doesnot take inactive portion of the transaction log on the backup (.bak file) but it is smart enough to remember the...
October 7, 2006 at 12:11 am
did someone try running
EXEC master.dbo.xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'
may be some issue with interface??
September 11, 2006 at 9:59 pm
You said that you are able to see the file on the disk and it works once you recycle SQL error logs.
What is the size of log file on the...
September 11, 2006 at 9:50 pm
Nice post with all steps. but....
DBCC REBUILD_LOG doesnot work with SQL 2005.
September 11, 2006 at 8:23 pm
What is the error message which you are getting?
Are you doing bcp from remote machine?
September 11, 2006 at 8:10 pm
I don't think taking only database backup is possible (without FT)
As per BOL
Generally, SQL Server performs these tasks during a BACKUP operation:
1. Temporarily suspends Microsoft Full-Text Engine for SQL...
September 7, 2006 at 8:21 am
Vik,
sp_attach_single_file_db will work if database was cleanly shutdown i.e. it was detached.
When sp_attach_single_file_db attaches the database to the server, it builds a new log file and performs additional...
September 7, 2006 at 8:16 am
I feel that its required .net framework which will be installed by SQL 2005 Setup CD itself.
Where exactly did you find this information?
September 6, 2006 at 9:52 pm
Can you please open it for the internet access. and revert back the query to
sp_fulltext_service 'verify_signature', 1
Let me know the results...
September 6, 2006 at 9:35 pm
Glad to know it helped.
One quick question. Does this box has access to internet?
September 6, 2006 at 12:54 pm
Viewing 15 posts - 166 through 180 (of 333 total)