This link tells you on STANDBY clause when restoring via SSMS

http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx

This link gives u step by step guidance to setup up log shipping in STANDBY mode

http://msmvps.com/blogs/omar/archive/2006/09/15/How-to-setup-SQL-Server-2005-Transaction-Log-Ship-on-large-database-that-really-works.aspx

If the database is in normal state, you cannot perform further restoration of log files.

The database must be either in NORECOVERY...

kirkwilson (6/14/2009)

---

Ok, I am setting up log shipping and everything seems to go as planned but the secondary database does not go into standby mode when the shipping is implemented....

When the recovery mode is full, all transactions remain in the log file. You have to...

sqlquestions15 (6/14/2009)

---

Can any one Help me ....I Need to Know that I have set my Database Log Gile size 20GB and it increase upto 40 GB.Need to Know about both...

DBCC SHRHINKFILE shrinks a data or a log file.

Shrinking here pertains to reclaiming unused spaces within a file. There are operations that happen in the database that lead to growth...

🙂

using cursors might not be the best option but still using cursors in this example.

let us know if it's fine.

DECLARE @val4 varchar(20),@val1 varchar(20),@val2 varchar(50),@val3 varchar(50),@Sql varchar(8000);

set @val1='SQLSRV'

set @val4=CONVERT(VARCHAR(10), GETDATE(), 101)

Declare...

mcgillivrayk (6/14/2009)

---

I am looking for a way to insert records into a child table that has a primary key from a parent table and a sequence number that increments for...

I'm not sure if this is the most efficient code but perhaps does your work

select 'Begin XXOH_INV_INTERFACE_PKG.insert_trx(' +''''+ convert(varchar,getdate(),101) + ''''+

',' +''''+'SQLSRV' + '''' +',' + '''' + ...

christian.benvenuto (6/8/2009)

---

Currently we backup and restore the entire DB. My thought was to move the history and archived tables to a separate filegroup and exclude it from the backup and...

As suggested by Florian, there must be some variable (may be within sp), which is defined as CHAR datatype, where in the value in the variable is automatically padded with...

Please do not cross post. All replies can be given here:

http://www.sqlservercentral.com/Forums/Topic733582-145-1.aspx

unless you have excessive amount of data getting inserted, most likely the cause is dbcc reindex.

Perhaps this link should help you.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112916

What i can think of is, DBCC REINDEX creates a...

Are you sure your mdf grew or ldf? reindexing causes the log to grow heavily.

Also, if you have performed DBReindex after quite long time, chances are the file has grown...