Viewing 15 posts - 436 through 450 (of 816 total)
I will suggest instead of changing the procedure, you should follow the policy.
Inform the person who have sufficient permission(like domain admin and system admin) on server for installation. Or...
December 29, 2010 at 11:40 pm
it could be of many reason. One of the main reason is of network.
Also you can see the detail in replication monitor.
December 29, 2010 at 11:01 pm
'xp_restore_verifyonly'
Seems like litespeed backup.
In addition to above point, you can put verification step just after backup job and keep writing the output in text file which you can...
December 29, 2010 at 10:54 pm
just for testing can you restore the database from the file which you thinking is of full backup and then differential in some test environment.
I am assuming there is some...
December 29, 2010 at 10:45 pm
for DTS, i will suggest to save them as file and then import them as file in ssms.
December 29, 2010 at 8:43 pm
saidapur_satish (12/29/2010)
Hi Gail,2.5 Year experience on SQL DB
first of all it doesnt matter how many yrs of exp you have as sqldba what matters...
December 29, 2010 at 12:49 am
http://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm
this is about 2000 but you will get basic idea about transactional replication.
Also if you search this website with your requirement then you will get plenty of useful information.
December 28, 2010 at 11:45 pm
if both database are identical and you refreshing your database with live database by every 4 hrs then you can consider transactional replication.
Or
if you want your data also need to...
December 28, 2010 at 10:25 pm
as it is mixed mode authentication, you can login with domain admin or if your windows id have enough permission on server and domain then connect the sql server with...
December 28, 2010 at 10:22 pm
if you have 2008 run activity mnitor for the instances.
if you in 2005 there are dmvs to check this.
if in 2000 check in sp_who2 'active' and see blocking spid. then...
December 28, 2010 at 9:48 pm
in perr-to-peer the other node is acting as subscriber, but as publisher. So both node will act as publisher and subscriber for each other
December 28, 2010 at 4:09 am
yes you can configure your production database for reporting purpose using log shipping.
for this you need to restore the database in standby mode so that you can read the...
December 28, 2010 at 2:01 am
use cursor to get the list of tablename and then run the insert statement in loop by taking tablename one by one
December 27, 2010 at 6:18 am
run this...
select name [database], suser_sname(sid) [owner] from master.dbo.sysdatabases
what it says? If still seeing the owner as your problamatic username then change it.
December 27, 2010 at 4:01 am
Viewing 15 posts - 436 through 450 (of 816 total)