I don't...

OK. good luck

I have already given you everything to handle a 15 minute transaction log backup. Just specify WITH NOINIT and see how it goes.

Append will work in transaction log too using the WITH NOINIT. The default is also append. You must be looking at something different. Easy way to see it:

create table...

2008 & 2008r2 will work. You will have to test it on 2003/sbs. if it doesn't work then try downloading that file mentioned in the URL.

I have no idea how the "points" works on this website. It seems to just be "posts" unlike on the Oracle forums where you receive points for correct/helpful answers o:

If...

It can be executed in a query to test it. First you would need to create the folders on...

I don't think a remote backup is really required. How many disks does your server have? Assuming there's one spare for backups you could just do this to maximise reliability:

backup...

OK so there is 3-4 databases for you to do transaction log backups of. They are changing/adding 100 records, is that per day? per hour? per week? How important is...

Yes.

Saggy (6/15/2013)

---

2. After that sql script of backup_tlogs.sql i have to save in notepad OR i have to save in...

The database will get larger as you include more data. Unless the...

BACKUP DATABASE your_database_name TO DISK='D:\db_15_06_2013.bak'

Run that in the query window & you will have a backup for the shortest time fix.

Then YouTube "sql server maintenance plans" and in 5-10...

Something like this will work:

A .bat file containing the following:

sqlcmd -S SERVERNAME\INSTANCENAME -E -d master -e -b -i d:\mssql\backup\backup_tlogs.sql -o d:\mssql\backup\backup_tlogs.log

Then in backup_tlogs.sql you would have:

DECLARE @name VARCHAR(50) -- database...

Why not use SQL Server Agent? XE?

You can see this example: http://snipplr.com/view/52490/%5B/url%5D