Viewing 15 posts - 211 through 225 (of 816 total)
stop the job which are doing log backup and copy to secondary server. Even if you do not stop this job, it will have no impact.
But your downtime is long...
June 8, 2011 at 5:12 am
Can anyone explain to me if other queries will be blocked by this query? And if this query also will be blocked by other queries? Explaination with details would be...
June 8, 2011 at 5:08 am
your question is not clear.
But I will answer based on 2 scenario:-
1) When you open RS Configiration Manager, it ask for server name and RS Instance name. Once you...
June 8, 2011 at 4:59 am
Network Administrator is ready to provide third party hardware which can copy log backups from A to B, so that I can restore the Trasactions to B. Is it...
June 6, 2011 at 4:06 am
That explains it - you're describing the 'Advanced' option of the 'Generate Scripts' wizard, not the 'Copy Database' wizard. There's an option when generating the scripts to select the target...
June 3, 2011 at 8:23 am
[
I get "The database 'TestDB' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported."
you might have ignored the...
June 3, 2011 at 7:56 am
are both sql server on same version?
Give some more detail about your linked server and security you configuring.
June 3, 2011 at 4:50 am
In SQL Server Management Studio open Linked Servers and then 'New Linked Server'.
1) Select the General tab.
2) Specify alias name in "Linked server" field.
3) Select SQL Native Client as provider.
4)...
June 3, 2011 at 1:56 am
new os means fresh new installation and configuration on windows and on sql.
post instaallation need to allocate the resource to group and their dependency.
Also be aware till the...
June 3, 2011 at 1:50 am
seems like conflicting with some objects.
Can you try to just replicate one table and see how it goes?
June 2, 2011 at 3:49 am
i dont have the code, but logic can be used as :-
Count the number of records being returned by query, if its 0 then :-
print :- "No records to display"
else
do...
June 2, 2011 at 2:19 am
seems like there is issue with your network to replicate commands/transaction across network to subscriber.
Open replication monitor and see the error there.
Try to resync it again if there are not...
June 2, 2011 at 2:09 am
the issue is not with sql but with network, thats what i can think of here.
Are both box in same domain or in different domain? what authentication you are using...
June 1, 2011 at 10:27 pm
This script will help you to generate the server role for existing logins:-
Declare @Prefix varchar(255)
Declare @tmpstr varchar(MAX)
Set @Prefix = '
exec master.dbo.sp_addsrvrolemember @loginame='''
Set @tmpstr=''
...
June 1, 2011 at 4:55 am
Viewing 15 posts - 211 through 225 (of 816 total)