Viewing 15 posts - 421 through 435 (of 491 total)
whats the Version of SQL Server?
Is there any activity if some one changed the model and then changed backup to the previous one ?
Last Full backup is done successfully ?
Regards,
Syed...
April 22, 2011 at 3:59 am
That is a serious issue,did you check to bounce the agent service,
for the time being create an sp and include all jobs start script as
sp_start_job 'test1'
sp_start_job 'test2'
and so on......
and then...
April 21, 2011 at 12:48 pm
Total CPU physical and logical
Total RAM
Total Drives not partitions
paste table script as well as trigger and indexes if on this table
select st.text,sp.* from sys.sysprocesses sp
cross apply sys.dm_exec_sql_text(sp.sql_handle) st
where sp.cpu >...
April 21, 2011 at 12:39 pm
How many processors in a server , did u set the max_worker_thread,OS version 32bit or 64bit,All databases are on different HDD or drive not partition
select st.text,sp.* from sys.sysprocesses sp
cross apply...
April 21, 2011 at 12:30 pm
If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe. For example, you can...
April 21, 2011 at 12:20 pm
MSDTC use for distributed transaction so its best to use a specific drive and i dont think you can use same disk for SQL instance binaries
if you define qurum drive...
April 21, 2011 at 12:06 pm
drop the Disk from cluster if you can connect ,otherwise tell to your SAN administrator to back that drive and again assign with new LUN number to the server
Regards,
Syed Jahanzaib...
April 21, 2011 at 11:59 am
can you prove this?
Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so
http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP...
April 21, 2011 at 11:48 am
I think I guess you are taking log backup with tail option,if this option check then database is come to restoring state,check this option also
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP...
April 21, 2011 at 10:33 am
mention your sp code
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 21, 2011 at 10:23 am
How much Processors and RAM allocated for VMWARE,which type of drives you have ,is there any RAID Level or SAN or NAS drive
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA...
April 21, 2011 at 10:21 am
db_dlladmin is available in the User_Mapping windows of a user in the security on a particular database
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP...
April 21, 2011 at 10:19 am
Indexes are created already ?
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 21, 2011 at 10:17 am
Start the SQL Server Browser service from the
CONTROL-PANAL ->Administrative Tools -> Services
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 21, 2011 at 10:13 am
select * from table_name where column='20110101'
mention columns which you have required in the selection and mention index scripts also
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE...
April 21, 2011 at 10:11 am
Viewing 15 posts - 421 through 435 (of 491 total)