Viewing 15 posts - 361 through 375 (of 860 total)
shahajic (4/2/2009)
We have some huge jobs running on sql server db 2005, which create transaction log and this log is backedup up every 15 min and copied over...
April 2, 2009 at 4:30 pm
bladerunner148 (4/2/2009)
April 2, 2009 at 4:23 pm
Yep, that's true even if it does come back the database will be in inconsistent state. So, probably we don't have any other option rather than restoring a fresh copy...
April 2, 2009 at 4:15 pm
SA (4/2/2009)
Even after you have a fresh copy of the database, you want to restore one copy at a time since reading from the same file may end up causing...
April 2, 2009 at 2:50 pm
sbrown (4/2/2009)
Not the owner, but I'm an administrator. Do I need to be the owner of the job?
Administrator by default is the owner of all jobs.
April 2, 2009 at 2:39 pm
SA (4/2/2009)
Even if you are able to restore from the same file on 2 servers, I would not recommend that since the restore will end up taking longer than usual.
Sorry,...
April 2, 2009 at 2:20 pm
Mike Levan (4/2/2009)
may be i have restore it again.Can i use a single bak file to restore on 2 servers simultaneously.
I think you should wait for the database to restore,...
April 2, 2009 at 2:06 pm
May be, May be not. But the database gets structurally inconsistent I guess, not so sure though.
but you can run this one though:
RESTORE DATABASE 'databasename' WITH RECOVERY.
April 2, 2009 at 2:00 pm
bladerunner148 (4/2/2009)
Now, I have to create indexes for 10 fields
That is where is the problem? Why do you have to create so many indexes? Is it that you are...
April 2, 2009 at 1:56 pm
Can you run this :
RESTORE DATABASES 'databasename' WITH RECOVERY, which will put it in recovery. Is this your production ?
and can you run DBCC CHECKDB please?
Is there anything in the...
April 2, 2009 at 1:42 pm
shivaram challa (4/2/2009)
"If we don't need to take a Transaction Log backup, Only then use shrink-log-file."
Even if we need or we don't need tlog backup we can still...
April 2, 2009 at 1:39 pm
shivaram challa (4/2/2009)
Krishna Potlakayala (3/26/2009) You would not be able to shrink the log file unless you truncate it. When the sys.databases "log_reuse_wait_dec" coulmn status is "LOG_BACKUP", then you should...
April 2, 2009 at 10:31 am
Yes may be you could try that just with the SQLAgentOperator role and dts admin role. without the User and Reader role- you don't need these if you have the...
April 2, 2009 at 7:47 am
Vera (4/2/2009)
And I'm changing the way the records are deleted and inserted.
I'm inserting in different steps so that...
April 2, 2009 at 3:41 am
Viewing 15 posts - 361 through 375 (of 860 total)