Viewing 15 posts - 61 through 75 (of 114 total)
http://msdn.microsoft.com/en-us/library/ms190673.aspx
will answer your Question...
Sagar Sonawane
** Every DBA has his day!!:cool:
November 22, 2011 at 11:42 pm
10240 as it is in MB.
AWE enabled???
Sagar Sonawane
** Every DBA has his day!!:cool:
November 22, 2011 at 11:33 pm
I guess in SQL Azure(11) % Denali(12) we can take backup on network drives.
-------------------
Sagar Sonawane
** Every DBA has his day!!:cool:
November 22, 2011 at 10:51 pm
PaulB-TheOneAndOnly (11/22/2011)
logicinside22 (11/22/2011)
I like your suggetion can you tell me in details which command should use to setup for this
Please follow the link I've posted in regards to how...
Sagar Sonawane
** Every DBA has his day!!:cool:
November 22, 2011 at 10:48 pm
You can search in google
type search query as "sql server basic filetype:pdf"
you will get lots of SQL server basic ebooks freely available.
I am not sure bout the book mentioned...
Sagar Sonawane
** Every DBA has his day!!:cool:
November 22, 2011 at 3:07 am
Really thankful for your guidelines, Grant and Gail & Paul.
Now my thoughts are very clear 🙂
Sagar Sonawane
** Every DBA has his day!!:cool:
November 20, 2011 at 9:48 pm
Anyway, you cannot script a SQL 2000 maintenance plan and migrate it to SQL 2008.
Just wanted to know how to migrate SQL 2000 maint plans
Sagar Sonawane
** Every DBA has his day!!:cool:
November 20, 2011 at 9:41 pm
I dont know much on Virtualization, Storage Area networks..... as per my knowledge these are used mostly in Large Environments..... please guide on the same and any other relavant technology...
Sagar Sonawane
** Every DBA has his day!!:cool:
November 18, 2011 at 12:50 am
VMware ESX/vSphere virtualization, Storage and Storage Area Networks (SANs) ....etc
Sagar Sonawane
** Every DBA has his day!!:cool:
November 18, 2011 at 12:31 am
You can use following script for the alert. Provided that your Db mail should be configured and working properly.
USE [msdb]
GO
EXEC msdb.dbo.sp_update_alert @name=N'Tempdb',
@message_id=0,
@severity=0,
@enabled=0,
@delay_between_responses=0,
@include_event_description_in=1,
@database_name=N'',
@notification_message=N'Logspace...
Sagar Sonawane
** Every DBA has his day!!:cool:
November 18, 2011 at 12:28 am
You can take Log BACKUP, provided that your Recovery model type should be FULL or Bulk Logged.
Sagar Sonawane
** Every DBA has his day!!:cool:
November 10, 2011 at 10:52 pm
george sibbald (10/20/2011)
MarkusB (10/20/2011)
I just noticed that the OP wants to migrate maintenance plans from SQL 2000 to 2008. So SSIS isn't an option after all.
so he does.
The ops only...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 20, 2011 at 11:44 pm
You can check with the permissions... there may be problem..
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:56 am
It gives the information about current locked objects
It shows Shared Lock & Int. Shared Lock mode.
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:36 am
Dev @ +91 973 913 6683 (10/13/2011)
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...
I am sorry but I...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:21 am
Viewing 15 posts - 61 through 75 (of 114 total)