I did setup log shipping and following were some of the files generated.

My db name is pubs_2000. Date on my machine while i tested this was 29th dec 2009. I...

I think what sanderstad wrote is correct. I just verified that by creating a maintainence plan. Can u check if the server time is different from your local system time?

Declare @src varchar(100)

Declare @dest varchar(100)

declare @str1 varchar(200)

--Declare source and destination paths

set @src='c:\backup\AdventureWorks_log_'+convert(varchar,getdate(),112)+left(convert(varchar,getdate(),108),2)+substring(convert(varchar,getdate(),108),4,2)+'.trn'

set @dest='c:\Develop\AdventureWorks_log_'+convert(varchar,getdate(),112)+left(convert(varchar,getdate(),108),2)+substring(convert(varchar,getdate(),108),4,2)+'.trn'

--Backup the log

backup log AdventureWorks to disk=@src

--Declare the string to copy the log file

set @str1='copy '+@src + '...

If the optimization job is running from...

if you're sure the database wont grow to its original size in near future, you can proceed with shrinking or else leave it at that size as it'll eventually grow...

If you are sure the db...

trayalacheruvu (7/28/2009)

---

hi,

Thanks for your quick update update.. Actually i am rebuilding the indexes every during the non-working hours.. ok after Shrink the Database i need to rebuild the indexes. the...

Didnt understand your language. Can u state the problem in English please as most of the members use english here....

Duplicate post. Pls post your replies here.

Duplicate post. Pls post your replies here.

BOL should be the place to start with, later you can search for additional resources.

http://msdn.microsoft.com/en-us/library/cc917688.aspx

EDIT-double post due to internet issue.

Yes, you'll face performance issues. This is due to the fact that shrinking causes fragmentation of...

sashikanta.mishra (7/28/2009)

---

Hello Guys,

How can i recover a table (data and Structure) after i drop that table.

I am Using SQL EXPRESS 2005 version.I have recovery model set as FULL for the...

Do we really need to stop the services? i...