Viewing 15 posts - 12,571 through 12,585 (of 39,936 total)
lshanahan (4/23/2013)
April 23, 2013 at 9:17 am
Raju Lalvani (4/23/2013)
April 23, 2013 at 9:15 am
pdanes (4/23/2013)
So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get incorporated?
When the...
April 23, 2013 at 9:10 am
I would agree with Gail on the shrink.
As for the size, there is no right size. If you are getting 2GB daily, 2GB might be fine for the size. I...
April 23, 2013 at 8:33 am
Your service account may not have rights to that path. Not all accounts will. You'll have to determine if that's the case.
If the db is recovering, you will have to...
April 22, 2013 at 3:51 pm
You don't need to map a drive. The service account for SQL Server logs into Windows. It can't see your drive mappings when you've logged in with RDP.
Instead, run the...
April 22, 2013 at 3:00 pm
You don't need to take anything offline to run a backup. If you take the database offline, you can't run a backup in SSMS.
As far as the mapped drives, the...
April 22, 2013 at 2:48 pm
If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.
You don't need a 140GB log,...
April 22, 2013 at 2:23 pm
aayushmail007 (4/22/2013)
Thanks Steve and Gila.if this is organization data what would you prefer ?
My first requirement will be to have space in drive
2nd recover when needed
Those are not the...
April 22, 2013 at 2:18 pm
Jeffrey Williams 3188 (4/22/2013)
GilaMonster (4/21/2013)
April 22, 2013 at 2:07 pm
My thoughts:
If you are updating this once and day, and it's your database, important, but not affecting others, here's what I'd do.
Change the database to simple mode. With updates once...
April 22, 2013 at 1:42 pm
Brandie Tarvin (4/22/2013)
Steve Jones - SSC Editor (4/22/2013)
Brandie Tarvin (4/22/2013)
April 22, 2013 at 11:33 am
Brandie Tarvin (4/22/2013)
Steve Jones - SSC Editor (4/22/2013)
April 22, 2013 at 11:33 am
I know Brandie will like this, and perhaps others. My 14yr old asked if he could go to Comicon in Denver with his friends.
Now I'm thinking I might need...
April 22, 2013 at 10:58 am
Viewing 15 posts - 12,571 through 12,585 (of 39,936 total)