Viewing 15 posts - 1 through 15 (of 56 total)
Yes you can set up multiple publications and subscriptions....
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
August 20, 2008 at 4:00 am
Use Full text search catalog for that.
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
August 20, 2008 at 3:00 am
Basically you have chosen the option during the Loggshipping setup to restore the database in No Recovery Mode that is why it is showing you the status of Restoring... Look...
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
August 20, 2008 at 2:52 am
You cannot use this view as the password stored is in encrypted format.
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 30, 2008 at 9:08 am
Hi, You need to do the following in order to install the SQL Server 2005 default instance.
First you need to uninstall the SQL Server 2000 default instance.
Then install 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
July 30, 2008 at 8:19 am
I am not seeking any more suggestions on this. I have written my own script for this task and I am not seeking any help from you lot. Do not...
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 30, 2008 at 7:26 am
Thanks for your suggestions but this is not me who written the script this is written by some one else in the company and that is why its really complecated...
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 29, 2008 at 9:14 am
Dont need to be rude. I have fixed my script without any of your help. Any way I want tell you that this is the company requirement. I know how...
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 29, 2008 at 8:46 am
Gilla Monster, I dont know why you are trying to change the subject of my post. Actually what I requested is that " IF SOME ONE CAN LOOK AND FIX...
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 28, 2008 at 6:05 am
Yes we are taking the full backup of the databases before we run this job. So this is not the problem the problem with this script is its 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
July 28, 2008 at 4:20 am
You need to do the following in order to enable the database mirroring on you server:
1: Open SQL Server Configuration Manager
2: Right-Click SQL Server serivice.
3: Click on Advanced tab.
4: On...
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 28, 2008 at 4:15 am
We need to run this as job montly after the month end. As I am working for big financial organization and this is the business requirement. I know what are...
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 28, 2008 at 4:07 am
You can either Remote Desktop the SQL Server machine OR Use SQL Authentication.
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 16, 2008 at 3:29 am
Guide lines to install any PATCH or SP is as follow.
Stop all SQL Server Services.
Install the SP or PATCHES.
Start the SQL Server Services.
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 16, 2008 at 3:22 am
You should not change your server name once the SQL Instance has been installed because in windows registery on some entries it still points to the old name. I think...
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 16, 2008 at 3:18 am
Viewing 15 posts - 1 through 15 (of 56 total)