Viewing 15 posts - 436 through 450 (of 629 total)
Mohit (3/12/2009)
FYI ... The permissions SQL Server uses to restore are that of the service account the MSSQLServer service is running under.Mohit.
Dat? I was trying to explain the permissions...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 12:50 pm
Any time... if it wasn't for newsgroups, forms, and many many blogs I follow .. I did be a lost too.
People on this form are great, some great people respond...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 12:45 pm
[font="Courier New"]DECLARE @T AS TABLE (Col1 INT, Col2 DATETIME, Col3 CHAR(1))
DECLARE @P AS TABLE (Col1 CHAR(1), Col2 DATETIME, Col3 INT)
INSERT INTO @T
SELECT 1,'12/1/2008','A' UNION ALL
SELECT 2,'1/10/2009','A' UNION ALL
SELECT 2,'3/15/2009','A' UNION...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 12:29 pm
FYI ... The permissions SQL Server uses to restore are that of the service account the MSSQLServer service is running under.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 12:04 pm
In the Maintenance plan if you click on the icon with in Maintenance window design the very last icon before "Servers..." (Reporting and Logging).
You can set the path there, by...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 11:56 am
This is the new security model for 2005. Instead of granting the Service account local admin what 2005 does is when you install it; it creates a local group...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 11:49 am
Table Size / Avg Index Fragmentation Percentage are two main ones.
The other ones to look at is Fill Factor & Pad Index; you should look at how your indexes are...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 11:42 am
General practice is not to mix SQL Server with other applications because it can run into resource contention issues. However that said I have multiple installs where they are...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 11:09 am
Another thing I use in addition to page information provided by Grant is .. avg_fragmentation levels. 1-25% re-org, 25% rebuild.
But again rebuild I only consider on very large tables.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 11:02 am
Mirroring wasn't supported until SP1. If you have mirroring running on local computer you will not be able to use server.local; it will not work. You have to...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 10:13 am
It should, 2008 and 2005 most of the catalogs are same; however I never used the function so I am unsure how well it will work ...
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 9:16 am
That value indicates how much of the memory is being used by security tokens alone. In SQL Server unless you are part of sysadmin group there is security tokens...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 9:10 am
*cheers* :w00t: :w00t:
Now you get to deal with other fun parts of mirroring hehe; make sure you implement T-Log backups with full db backups on both servers. SQL Server...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 8:29 am
No problem we can get Steve to relocate the topic, if he wishes. Can you please check if see if you have USER token issue?
Could you please run:
select sum(single_pages_kb+multi_pages_kb)...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 8:27 am
Probably then a central server running SQL Server with desktop apps connection to the SQL Server.
Choice of lanugage then comes down to what you are comfortable with :). Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 7:09 am
Viewing 15 posts - 436 through 450 (of 629 total)