Viewing 15 posts - 856 through 870 (of 1,069 total)
raymondpe (4/26/2008)
ok this worked for me..... just in case anyone has to do this:> RESTORE DATABASE master FROM DISK = 'C:\MINIDR\masterbackupfile.bak' WITH
RECOVERY, REPLACE;
2> GO
Problem solved.
Hi Raymond,
I had same problem...
December 28, 2008 at 12:52 am
Do you find the problom ? why the second request was not suppended by the first request?
I don't find any problem. The seconds request is blocked by the first...
December 26, 2008 at 4:22 am
This database is very critical for us,Could it be possible that after reindexing it will be not responding....?
No. Reindexing should not cause any problem.
December 26, 2008 at 4:07 am
use postnet
go
alter index all on TempLan_Details rebuild
December 26, 2008 at 12:39 am
Table error: Object ID 293576084, index ID 0, page (1:636), row 15. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 46 and 130.
Server: Msg 8928, Level 16, State 1, Line...
December 26, 2008 at 12:26 am
When <> (not equal to) condition is used table scan happens because all the records are to be compared.
December 25, 2008 at 11:30 pm
Is there any explanation in the SQL Server Log?
I think the orginal database (in SS2K) has issues. Have you run DBCC CHECKDB before taking backup?
December 25, 2008 at 11:22 pm
Can anyone tell me what are the advantages and disadvantages of SQL EXPRESS please.
1. Database size cannot be more than 4 GB
2. More than 1 CPU is not used
3....
December 24, 2008 at 12:34 am
SQL Server B (2005 EE), in Domain B, will also receive data from a custom app - but this should be separate data to the data being received by the...
December 24, 2008 at 12:15 am
Just USE master database instead of the one you want to restore.
use master
go
BACKUP DATABASE DATA_SAMPLE TO DISK='E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DATA_SAMPLE.BAK'
RESTORE DATABASE DATA_SAMPLE FROM DISK='E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DATA_SAMPLE.BAK' WITH NORECOVERY
You...
December 23, 2008 at 10:08 pm
Profiler shows SPID and Client Process ID.
If AppliationName is not mentioned in the ConnectionString, you can use Client Process ID to detect it (using Task Manager as mentioned in the...
December 23, 2008 at 5:22 am
Can anyone tell me the difference between SPID and Process ID?
SPID means Server Process ID.
Just Process ID can mean Client Process ID as well.
December 23, 2008 at 4:34 am
Setup will upgrade only from lowever version to higher version (e.g. SQL Server 2000 to 2005).
To upgrade only the edition, you should run following command:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine...
December 23, 2008 at 4:26 am
i want to execute it automatically for that job concpt have to use right ? am new to job concept ! whether have to create a job to execute the...
December 23, 2008 at 3:58 am
how to configure copy_only(Back up & Restore i read some articals) that command eaisly contionous back up in sql server 2005. Colud plz guide to me and how configure copy_only...
December 23, 2008 at 2:23 am
Viewing 15 posts - 856 through 870 (of 1,069 total)