Viewing 15 posts - 16,981 through 16,995 (of 19,560 total)
cute_lhen05 (2/25/2010)
we use the database often thats why we dont schedule it hourly;is there another option? thanks
A common practice is to backup the transaction log every 15 minutes. ...
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
February 26, 2010 at 12:38 am
If I am to understand you correctly, it appears that you only backup your transaction log once a day as part of your backup maintenance plan which also performs 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
February 25, 2010 at 10:58 pm
WayneS (2/25/2010)
The "correct" answer doesn't have a column in the where clause... how can that be SARGable?
I would have to agree here. The lack of a column in 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
February 25, 2010 at 10:55 pm
Database names within an instance must be unique.
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
February 25, 2010 at 10:42 pm
You might want to look into a ddl trigger at the database level or the use of event notifications. Either of these options could alert you to somebody trying...
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
February 25, 2010 at 10:40 pm
A login gives you access to the server.
User gives you permissions into a database.
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
February 25, 2010 at 10:36 pm
Which database is it (system or user)?
We had an issue with our tempdb doing the same thing. We fixed it by changing the model db settings.
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
February 25, 2010 at 10:35 pm
Here's a link on how to restore backups.
http://msdn.microsoft.com/en-us/library/ms177429.aspx
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
February 25, 2010 at 10:27 pm
cute_lhen05 (2/25/2010)
Its already in full recovery and the transaction log backup is already included in the database maintenanceplan;thanks
What is the frequency of your Tlog backup?
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
February 25, 2010 at 10:24 pm
Are you in full recovery mode?
If so, then you need to be backing up the log file on a regular basis in addition to your full backups.
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
February 25, 2010 at 10:03 pm
Welsh Corgi (2/25/2010)
For roles within the Database use the following command:sp_helprolemember
http://msdn.microsoft.com/en-us/library/aa933454(SQL.80).aspx
For Roles at the Server member use the following command:
sp_helpsrvrolemember
This is a good suggestion. There are...
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
February 25, 2010 at 1:28 pm
Steve and Wayne, nice solutions.
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
February 25, 2010 at 11:51 am
It is a good list, and there are good reasons to attend regardless of the date (2009 v 2010).
See you all there. 🙂
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
February 25, 2010 at 11:48 am
Nice series, thanks.
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
February 25, 2010 at 11:44 am
Indianrock (2/25/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
February 25, 2010 at 11:18 am
Viewing 15 posts - 16,981 through 16,995 (of 19,560 total)