Viewing 15 posts - 31 through 45 (of 61 total)
Any thoughts in general on restoring a database from a 10gb database backup(6gb data, 4gb log) that would generate a 10gb data file and a 40gb log file?
September 13, 2012 at 12:36 pm
I appreciate your experience and knowledgable answers on this somewhat minor subject I raised here. In scanning blogs/forums, I see on other topics, like using special characters in your...
September 13, 2012 at 8:36 am
What prompted me to question this was my coworker said it was a best practice when showing me a database design. I remembered Paul's video from an earlier viewing...
September 12, 2012 at 8:08 pm
andersg98 (8/13/2012)
At the risk of adding confusion you can connect to an instance using a nonstandard (not dynamic) port and the server name without the browser service.example: Servername.domainname\instancename,port_number
not confusing,...
August 14, 2012 at 6:38 am
Thank you all for reading and thank you Perry for your replies. 🙂 Great community here.
One last question.
Is it possible for 2 SQL Server instances running on the...
August 13, 2012 at 1:10 pm
So,
Browser service needed:
1. If connecting using only the instance name with a non-standard port
2. If connecting to an instance that uses dynamic ports, such as a named instance because it...
August 9, 2012 at 8:24 am
SQLRNNR (8/7/2012)
Keep in mind that should you ever need to use the dedicated admin connection, the browser service will need to be running and 1434 will need to be accessible.
Didn't...
August 8, 2012 at 8:12 am
I like your idea, encrypt the results of the query that is then sent by sp_send_dbmail.
I'll look into a solution involving both.
Thanks you!
June 13, 2012 at 2:17 pm
The following link will explain the data this gives you.
http://msdn.microsoft.com/en-us/library/ms188776.aspx
It uses a combo of sp_msForEachTable and sp_spaceused to gather the data.
Enjoy.
SET NOCOUNT ON
CREATE TABLE #T
(
table_name NVARCHAR(128)
,[rows] CHAR(11)
,reserved...
June 5, 2012 at 9:11 am
MDFs, NDFs, and LDFs are locked files. When you do a full system backup, have MDF,LDF, and NDFs put in your exclude list.
If you did a full system restore...
May 25, 2012 at 2:07 pm
I do that as well, esp C# coding, since I don't write it everyday. Its a good practice.
May 18, 2012 at 6:58 am
Thanks for the reply. I can write the code I see him using and experiment. I'll piece something together well enough.
May 18, 2012 at 6:36 am
If it is SQL 2005/8 on Server 2003 x86 with 4 gb of ram, use the following
Min server memory at 1gb
max server memory at 3gb
This assumes one instance of sql...
May 18, 2012 at 5:44 am
Thank you everyone for the replies. I was looking for more of an alert than waiting for a job to run to show me failed jobs. That is...
January 11, 2012 at 6:38 am
Was there any resolution to this issue? Why does an 017 get generated on successful login.
Is 017 only appliciable to logging into sql server, or does it also apply...
January 9, 2012 at 10:54 am
Viewing 15 posts - 31 through 45 (of 61 total)