Viewing 15 posts - 61 through 75 (of 114 total)
http://msdn.microsoft.com/en-us/library/ms190673.aspx
will answer your Question...
November 22, 2011 at 11:42 pm
10240 as it is in MB.
AWE enabled???
November 22, 2011 at 11:33 pm
I guess in SQL Azure(11) % Denali(12) we can take backup on network drives.
-------------------
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...
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...
November 22, 2011 at 3:07 am
Really thankful for your guidelines, Grant and Gail & Paul.
Now my thoughts are very clear 🙂
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
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...
November 18, 2011 at 12:50 am
VMware ESX/vSphere virtualization, Storage and Storage Area Networks (SANs) ....etc
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...
November 18, 2011 at 12:28 am
You can take Log BACKUP, provided that your Recovery model type should be FULL or Bulk Logged.
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...
October 20, 2011 at 11:44 pm
You can check with the permissions... there may be problem..
October 13, 2011 at 1:56 am
It gives the information about current locked objects
It shows Shared Lock & Int. Shared Lock mode.
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...
October 13, 2011 at 1:21 am
Viewing 15 posts - 61 through 75 (of 114 total)