Viewing 15 posts - 826 through 840 (of 1,790 total)
Do you know what file(s) is using the space? Is this strictly the data file that grew or is the log file a part of the size that you are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:31 am
Really the steps are fairly simple with one complexity that you want to ensure you have something in place to work around. So, a brief outline as follows;
1. Configure...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:25 am
A couple of quick thoughts, MS may not support replication of the database in relation to their application but you are only doing this for reporting so, you could set...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:11 am
hemant789 (2/4/2009)
So what I have to refer dump file which is created in the SQL server Log directory or sql error log from enterprise manager/management studio?
After the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 6:11 am
Just glad that you were able to get the instance back up. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 3:14 pm
...because someone changed them 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 2:15 pm
How about with sqlservr.exe -m? Still seems to be a permissions issue though based on the errors but we do know how those are sometimes. 🙁
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 1:23 pm
Does your command look something like this?
sqlservr.exe -d F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf -l F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
The last location should match your error log...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 12:44 pm
SA (2/4/2009)
2009-02-04 13:22:49.60 spid4s ...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 12:15 pm
SA (2/4/2009)
Obviously,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 12:11 pm
Have you recreated the folder where TempDB should reside? Do this first if not and post back with information. Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 11:55 am
Lynn Pettis (2/4/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 11:21 am
Yeah, the only way to truly offload all the loading performance impact would be to do it on another server and copy the newly loaded database (Options 1 and 2)...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 9:41 am
Mike Levan (2/4/2009)
1. Can the staging table and production table be on different servers/databases and how does that if effect perofrmance with different servers.
2....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 9:22 am
Michael Earl (2/4/2009)
To me, "INSTEAD OF" triggers always feel like "INSTEAD OF DOING IT CORRECTLY" triggers. They are great for a stop-gap when you need to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 4, 2009 at 8:25 am
Viewing 15 posts - 826 through 840 (of 1,790 total)