PK understanding is PRIMARY KEY and if you see prefix like PK in a table indexes then its mean table have a PRIMARY KEY with clustered Index.when we create a...

Database Size ?

Log Size ?

you are taking backup as Network ,Tape or SAN

example

Network Backup like

\\servername\sharedfolder\filename

this storage is SAN , NAS or network path , IF this SAN did you...

Total CPU physical and logical ?

Total Ram ?

Total SQL Server RAM ?

OS 32bit or 64bit ?

check this query

Select st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

where cpu >1000

order by cpu...

There is no difference betweem mdf and ndf,Its just for understanding this is PRIMARY file mdf and then others are SECONDARY like ndf, you can create mdf also both files...

create checkpoint then take log backup and then truncate log files

CHECKPOINT;

BACKUP LOG [TEST] ......

GO

DBCC SHRINKFILE('Log file 1 name',TRUNCATEONLY);

DBCC SHRINKFILE('Log file 2 name',TRUNCATEONLY);

GO

take orignal and final backup some other place then...

1-Backup and Restore most reliable

2-Bulk Insertion fastest

you want to copy in 1 go there is no need of log shipping

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP |...

dont create more files in a single head or single drive

|Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

check the SQL Server agent service account it is working or not if you are using domain account for this service

is SQL Server machine name is changed after DNS changed...

1-Take a full backup and restore this database with different name

2-USE SQL Server IMPORT/EXPORT Utility

3-Write a simple ETL process in SSIS(SQL Server Inegration Services)

4-If these are simple tables then use

INSERT...

First of all apply Service Pack of SQL Server 2008 if you are not using R2,If your Maintenance plan execute on the Integration Service of SQL Server so that could...

First of all you should know the Server specification as

TOTAL CPU physical and logical

TOTAL RAM

TOTAL SQL SERVER RAM

OPERATING SYSTEM Version and 32bit or 64bit

TOTAL drivers not Partition

INSTANCE tuning is...

Data Access Objects (DAO) is not properly registered.

-or-

One or more references are missing.

-or-

There is a utility database reference that is not valid.

-or-

You do not have the required permissions for required...

Default name and default port do not required to mention in the connection you can use (.),LOCAL and System name only

You should first check the connectivity on the same server...

1-Check this SP_WHO2 for Processes which those are going to hang as on runnable state or suspended

2-Query

SELECT st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

order by sp.cpu desc

TOTAL CPU physical and...

Do you have any history purge job and did the last full backup done successfully

Regards,

Syed Jahanzaib Bin Hassan

MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA

My Blog

http://www.aureus-salah.com