Viewing 15 posts - 7,486 through 7,500 (of 9,244 total)
Is this a clustered install by any chance??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2010 at 2:16 am
ALZDBA (10/24/2010)
- Why don't you just directly 7zip your existing full backup file(s) ?
that's what i wondered!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2010 at 9:29 am
YSLGuru (10/12/2010)
Change the Recover Model to SIMPLE and flush out the Log file so that it is as small as possible.
Generally, but this doesn't always happen!
7zip is free, use this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2010 at 8:56 am
dcohn99 (10/23/2010)
What size is the log set to be to determine when it is 70% full? Can you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2010 at 7:04 pm
Firstly SP_Attach_DB is deprecated in future versions of SQL Server the following statement should be used instead
CREATE DATABASE FOR ATTACH
The link you posted is fairly dated and really only applicable...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2010 at 3:19 am
chetanr.jain (10/23/2010)
Well, i am surprised to see that.. Why the log is been at 100 GB. Why checkpoint has not been occurred.
When the database is set to truncate on checkpoint...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2010 at 3:01 am
richsilv (10/22/2010)
In your opinion, what is the advantage of using it over what I did?
Using detach\attach to move database files is not the MS recommended way to achieve this. It's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 4:16 pm
Learn_something_new_everyday (10/22/2010)
We don't write the code we just have to support it.
😉 tell me about it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 2:35 pm
why did you detach and re attach, why didn't you just use
ALTER DATABASE MODIFY FILE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 1:38 pm
Craig Farrell (10/22/2010)
Logs, even in simple mode, are incredibly important. They just take up less room.
this is not necessarily true, it is possible to have huge log files even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 1:32 pm
it would default to the Computers OU but could be moved almost anywhere. Go into AD users and computers console and in the left pane right click the domain and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 11:22 am
OK, I'm slightly confused here!!
Duran (10/22/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 9:43 am
dcohn99 (10/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 9:26 am
icampbell (10/22/2010)
synchronise
Elaborate a little more for us could you please?
Exactly what is it you intend to do?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 9:17 am
SkyBox (10/22/2010)
Yeah - I noticed that the maint. plan cleanup uses the XP_Delete_File proc.Thanks Perry
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2010 at 9:12 am
Viewing 15 posts - 7,486 through 7,500 (of 9,244 total)