Viewing 15 posts - 811 through 825 (of 1,539 total)
I think log shipping was introduced in sql 2000. prior to that it was all manual process of shipping logs to secondary. In 2000 Enterprise edition, we got automated log...
July 3, 2009 at 4:51 am
guptaajay1985 (7/2/2009)
Thanx...Yes it is working, Can u please tell how to decrease the time lag...
check out for these jobs and increase the frequency with which they run.
July 3, 2009 at 12:35 am
ramyours2003 (7/2/2009)
since we ve requirement that the dev server is gng to decomission soon .. so any measurements to be taken while restoring to production
Do you mean to...
July 2, 2009 at 12:10 pm
If you clarify more on your requirements, someone would definately help you out. From what u've written, all i can say is take backups of both databases in case something...
July 2, 2009 at 9:21 am
charipg (7/2/2009)
pls give the good links for learn clustering.(for administartion purpose)
I'd start with BOL first. then would refer to numerous articles on this site as well as some other sites.
July 2, 2009 at 8:46 am
that depends on how much data is present in the mdf and the free space. You can take a backup on disk and then compress it using utilities like winzip...
July 2, 2009 at 8:44 am
I remember this question was asked couple of days back and the poster had asked what was the need of restoring dev data to prod and what will happen to...
July 2, 2009 at 8:41 am
I dont think renaming an instance is possible. You can install a fresh named instance.
July 2, 2009 at 8:40 am
This is unusual. Can you click on the script button at the top of the backup window in SSMS? and see the difference between the script SSMS is using and...
July 2, 2009 at 6:32 am
guptaajay1985 (7/2/2009)
Can u tell me?After how much time my data will be reflected to the secondry server,
The moment your transaction log is restored on the secondary server successfully, u'll be...
July 2, 2009 at 6:29 am
To add to Randolph's backup plan, dont forget to backup your resource database as well besides other system/user databases.
July 2, 2009 at 6:25 am
Please clarify on Distribution server failure... Do you mean ur distribution server crashes? in that case u'll need to reinitiatlize ur subsriptions.
If you're referring to log agent failure, you can...
July 2, 2009 at 6:21 am
SQL Server 2000
Security:Owner = Schema, hard to remove old users at times
Encryption:No options built in, expensive third party options with proprietary skills required to implement properly.
SQL Server 2005...
July 2, 2009 at 6:17 am
are you able to access the disk through windows?
also can u fire backup manually?
backup database yourdatabase to disk='I:\Backup\SAPBACKUP_DISK.bak'
July 2, 2009 at 6:12 am
We dont have a page footer as far as i know. However, i may personally consider this row offset as page footer which contains information about row offsets on the...
July 2, 2009 at 6:07 am
Viewing 15 posts - 811 through 825 (of 1,539 total)