Viewing 15 posts - 8,551 through 8,565 (of 9,241 total)
releasing space can be wasteful of resources. Space in the file wil be required to carry out the action, so it'll only grow again and have you going round in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2009 at 11:53 am
Gail, who knows i'm with you on this!
BTW happy new year 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:13 am
Daksin
as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be kicked out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:11 am
GilaMonster (12/31/2008)
Full backup's not going to fix the problems the shrink caused,
Gail, i see where Paresh has gone with this. He advises that after truncating the log and breaking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 8:02 am
Dugi (12/31/2008)
ps (12/31/2008)
we dont have double post. we've 5 posts on the same topic!!
Yes I can see for that reason I told Steve that the SSC board should have more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2008 at 3:27 am
also remembering from another of your posts,
did you set the "lock pages in memory" policy on this server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:23 pm
BTW nice script Jeff
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:09 pm
dholland (12/30/2008)
Just checked:
Microsoft SQL Server Management Studio9.00.1399.00
That is SP1. My server is on SP2, let me...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:06 pm
DBADave (12/30/2008)
TREND - Anti-virus (not real-time)CSA - Cisco Security Agent
Double-Take - Replication to Disaster Recovery server
great, bound to be a few memory leak issues with that little lot installed.
you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:00 pm
you need to size the log file appropriately to handle transactions between backups.
what is the recovery model of the database set to at the moment?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 1:08 pm
oh dear madhu you are in a pickle arent you.
what do you have min and max memory set to on node 1?
have you thought about setting up a sql trace...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:54 pm
what does the following query return on the server you are having problems on?
select @@servername
it sounds as though the sql instance cannot be verified and hence it thinks no service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:46 pm
have you tried opening the job remotely through SSMS on another machine?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:31 pm
a compatibility version of 80 doesnt mean you can restore the database back to sql2000.
as previously pointed out you would be well advised to make sure that both environments use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 10:35 am
interesting links, so basically if it all went horribly wrong and 1 file filled up for some reason all the data would be written to just 1 remaining data file....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 10:22 am
Viewing 15 posts - 8,551 through 8,565 (of 9,241 total)