Viewing 15 posts - 16,636 through 16,650 (of 19,560 total)
YSLGuru (3/10/2010)
...and so far most of the replies have said I can't do a restore without those system DB's whcih is just untrue.
Nobody has said that you need...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 3:54 pm
If you are doing a backup and restore, you would not need to copy the mdf and ldf file from the source server. You would use the backup file...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 2:57 pm
If the old domain is going away, then you may need to re-add any domain accounts or groups (especially if that group or user is not currently in the new...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 2:32 pm
Here is a basic query to give basic info. There are other queries available online that could give you something different if need be.
select top 10 backup_start_date,backup_finish_date,type,backup_size,database_name
from backupset
Order by...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 2:06 pm
For the issue that Elliott raises, the following doc may be of use.
http://support.microsoft.com/kb/280297
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:36 pm
Try this site:
http://social.technet.microsoft.com/Forums/en-us/categories/
There are forums sponsored by MS for just about everything under the MS Sun.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:34 pm
Others are Idera Diagnostic manager, Redgate now has a tool, Confio has a tool, Spotlight, and the homegrown monitoring solutions that many will implement. Each will have pros and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:21 pm
Have done it in the past and it has been helpful. Our implementation was that each mount point was represented as a folder on the "Drive." This was...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:18 pm
There are other methods, but backup restore will likely be the fastest.
Once you restore the database, make sure you verify the logins work.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:05 pm
sandip.vs (3/10/2010)
Finally i figured out the problem...its because of Blocking and Locking issues.......But i don't have much idea how to solve those issues.....Can u guys throw some light on it???Regards,
Sandeep
The...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 1:04 pm
One more suggestion along with how to grant the permissions is to grant the permissions to a role. Then add that user to the role rather than granting permissions...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 12:55 pm
Thanks Tim. I will add this to my tool-set.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 12:49 pm
Elliott W (3/10/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 12:37 pm
HAHAHA
I look forward to the weekly comic. Helps the week go by faster.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 12:24 pm
Lynn Pettis (3/10/2010)
GilaMonster (3/10/2010)
Memorising questions will not help you in an interview. An experienced interviewer can easily tell the difference between someone who knows the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2010 at 12:22 pm
Viewing 15 posts - 16,636 through 16,650 (of 19,560 total)