Viewing 15 posts - 16 through 30 (of 56 total)
I think the best way to do this job is to set up the Log Shipping.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
July 14, 2008 at 6:04 am
You can use this proc to restore your database...
------------------------------------------------------
EXEC master.dbo.xp_restore_database
@database= 'Pubs'--Database Name
,@filename= 'C:\Pubs.bak' -- Backup File path
,@filenumber=1
,@WITH='REPLACE'
,@WITH='RECOVERY'
,@WITH = 'MOVE "Pubs_Data" TO "C:\Data\Pubs_Data.mdf"'
,@WITH = 'MOVE "Pubs_Log" TO "C:\Data\Pubs_Log.ldf"'
,@servername...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 30, 2008 at 6:46 am
Can you please write the error number and the full message.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 29, 2008 at 3:44 am
Or use this for fragmentation
USE MASTER
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO
CREATE PROCEDURE sp_DBA_DBCCShowFragAll
AS
BEGIN
DECLARE UserTables INSENSITIVE CURSOR
FOR
...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 29, 2008 at 3:42 am
Use this to view fragmentation in percent
SELECT
OBJECT_NAME(object_id) AS 'Object Name'
,index_id
,index_type_desc
,avg_fragmentation_in_percent
FROM
sys.dm_db_index_physical_stats (DB_ID(),NULL, NULL, NULL, 'LIMITED')
WHERE
avg_fragmentation_in_percent > 30
ORDER BY
OBJECT_NAME(object_id)
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 29, 2008 at 3:40 am
Now my next question is what PORT you are using to connect to the database. I mean what port your SQL Server service is using. Check if you can telnet...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 3:07 am
SQL Server Enterprise edition can only be installed on the following Server OS:
Windows Server 2000 with SP4
Windows Advanced Server 2000 with SP4
Windows Datacenter Server 2000 with SP4
Windows Server 2003with...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 2:51 am
CREATE TRIGGER EmplDeleteTrigger
ON Empl
AFTER DELETE
AS
BEGIN
INSERT INTO EmpDup (@EmpID, @Name, @Salary )
END
GO
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 2:36 am
Can you please tell what account the service is running under. If it is running under different account then check if that account has permission on the database server.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 2:31 am
Schema are logical container to store database objects and are used for security purposes for example let assume I have 10 tables in my database that needs to be viewed...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 2:28 am
If you have read the introduction it cleary states that it is the Enterprise only edition. Please read carefully before you comment on any thing.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 27, 2008 at 9:28 am
I looks that this post text is just a copy/paste from some book chapter which is the voilation of copyrights can you please tell what actually is not working.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 27, 2008 at 8:09 am
You dont need to kill the process because SQL Server automatically kills the process that is creating that deadlock by using its internal deadlock manager.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 27, 2008 at 6:43 am
The best way to do that task is to use Import/Export wizard....
Follow these steps.
1) Right Click the database from which you want to transfer the data.
2) Choose Export from the...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 27, 2008 at 5:48 am
Before deleting the builtin administrator account make sure you have another account that has administrator rights. Also make sure your SQL Server or SQL Agent services are not runnig under...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 27, 2008 at 5:42 am
Viewing 15 posts - 16 through 30 (of 56 total)