Viewing 15 posts - 976 through 990 (of 1,179 total)
Yes, you can add where clause in the above query:
select db_name(database_id),type_desc,physical_name from sys.master_files where type_desc = 'LOG'
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 24, 2009 at 4:22 am
What's frequency of log backup?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 24, 2009 at 4:14 am
I guess you are loged on with your domain\yourusername and running the backup so it's giving your info in profiler. Now in schedular you are using SSA so you just...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 23, 2009 at 2:42 am
I guess you need to change server name as you would like to execute it on new server but make sure and test it on dev or test environment before...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 23, 2009 at 2:26 am
You need to add "Maintenance Cleanup Task" with desire retention period of Database Bakup.
HTH
Cheers
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 23, 2009 at 2:11 am
Thank you, Gila for clarification and prompt reply.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2009 at 3:17 am
Refer link:
http://technet.microsoft.com/hi-in/library/cc917680(en-us).aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2009 at 2:57 am
Thank you Gail for such a Wonderful article 🙂
A quick question:
???If database is corrept and we are taking backup.... does backup too have corruption?
???If we are restoring the database with...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 18, 2009 at 1:11 am
however you need to creat "History clean up task" to clear history else it will there and unless and untill manually deleted it.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 12, 2009 at 6:15 am
Also I doubt that mirroring is not in sync hence unable to truncate the data from log on production.
Make sure your mirroring is working find before taking any steps.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 12, 2009 at 12:56 am
No terry,
Still there are lost of new features are there which DBA can target. eg. high availability like mirroring, Snapshot, service broker, clr intigrity, xml and much more etc....
I feel...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 12, 2009 at 12:35 am
Best way to do this is use Data modeling tool like ERwin.
Alternate is creat Script for the same.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 10, 2009 at 3:23 am
If your database is Production than after changing db back to Full recovery mode do not forget to take full backup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 9, 2009 at 4:17 am
can you try following code:
-----------------------
DECLARE @cmd nvarchar(2000)
SET @cmd = 'EXEC master.dbo.xp_delete_file 0,N''\\ServerName\C$\SQL Data\MSSQL.1\MSSQL\LOG\'',
N''txt'',N''' + CONVERT(nvarchar(256),Dateadd (dd, -6, getdate()), 101) + ''''EXEC (@cmd)
---------------------------
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 4, 2009 at 5:29 am
Think about the Packaging of SQL Server 2005.
It will help you to retain the standard as well as minimal knowledge.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 3, 2009 at 6:35 am
Viewing 15 posts - 976 through 990 (of 1,179 total)