Hi All, I have exact same problem. After restoring All DBs to another server, I use sp_help_revlogin to script out logins and passwords and run the...
How about re-indexing Master database? I ran dbcc showcontig on master db, the scan density for some the indexes is really low some with 13%. What do...
Satya, taking differential backup using WITH INIT option will delete previous backups but I need to keep 2 days differential backup...how do I do...
Hello Experts, Is there a way to delete old differential backups? I created a job and added a step for each database that i want differential backup...
Hi all, We take full backup on databases everynight and keep 2 days worth of backup. The maintenance plan deletes the older files then 2 days but...
Please help me resolve this issue! I have created a maintenance plan that takes full backup every night and deletes 2 days old backups. It was...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
quote:Originally posted by thomas You just prepare a script for the detach and then the attach and run them at the appropriate times. you need to...
quote:Originally posted by thomas You could detach the databases from the old server and attach them onto the new one. What woulb be my downtime?...
But, How is SQL server going to recognize the DBs on SAN? I mean we install a fresh copy of SQL server on the new server and lets say network guys...
Thanks a lot Mohammed for quick response.. Just a basic question!! Is the size of trn log backup of one day and differential backup equal? If not,...
quote:Originally posted by MohammedU Yes, you can present existing drives to new server but it depends on your SAN and server configuration. Check...
Hi All, I need to implement a backup strategy for the 2 production servers with about 100GB of DBs on each. Currently, We are taking Full backup...
Hello Experts, We are going to replace our production servers with the new ones. We have procedure that will guide us step by step to complete this...
As in you responded (ALZDBA) that you switch to the bulk logged then run reindexing so at that time do you stop transactional log backup or that...
Please help I'm a new dba and disregard if the question seems silly. Situation: At my current environment, full backup on nightly basis and trn log...
Separate names with a comma.
