James' SQL Footprint

Generate restore script automatically by backup history table

I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select a best restore solution base on the backup history table.

For instance, if you backup the database as the sequence below

ID	backup_start_date	backup_type
1	2012-04-30 18:28:43.000	Full
2	2012-04-30…

2 comments, 1,255 reads

Posted in James' SQL Footprint on 30 April 2012

Setup database mirroring and log shipping together

SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they don't need special hardware.

here is a great article about how to setup the database mirroring and log shipping together.
http://technet.microsoft.com/en-us/library/ms187016.aspx

In our system, we setup data mirroring with high-safety…

0 comments, 2,121 reads

Posted in James' SQL Footprint on 21 April 2012

script system object in resource database

When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or msdb database. for instance, in the master. [sys].[sp_add_log_shipping_secondary_primary] , it calls sys.sp_MSprocesslogshippingjob to create the copy job, however, sys.sp_MSprocesslogshippingjob is in the resource database, we can not review its code with sp_helptext command.

0 comments, 274 reads

Posted in James' SQL Footprint on 19 April 2012

Log shipping setup problem

Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping.

there are 2 monitor tables after logshipping setup
1. log_shipping_monitor_primary
This table has entries for all primary database on primary server and monitor server

2. log_shipping_monitor_secondary
This table has entries…

0 comments, 441 reads

Posted in James' SQL Footprint on 18 April 2012

Why I can not connect sql server ???

Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got error.

1. Enable TCP protocol
I tried to login sql server by SSMS with Server Name "MachineName\InstanceName", and select the Network protocol "TCP/IP"

but got error message below

My…

0 comments, 2,333 reads

Posted in James' SQL Footprint on 10 April 2012

Why shrink sql server data file failed?

Today I need to shrink a big data file, I know shrink file is not a best practise, and it will cause data fragment, but sometimes after you clean the database with deleting old data, you had to shrink file, it should be fine as long as you run rebuild…

2 comments, 663 reads

Posted in James' SQL Footprint on 7 April 2012

Clean SQL Server Cache

I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet with vacuum cleaner, wash clothes with machine. the clea enviroment makes me feel confortable, and have a good start for the new week.

SQL Server memory cache just like…

0 comments, 2,589 reads

Posted in James' SQL Footprint on 6 April 2012

SQL Server 2012 license

Not sure if it is a good news or bad news, SQL Server 2012 license shifts from processor-based to core-based.......here are the changes

1. There is no Datacenter Edition anymore, it is merged into Enterpise Edition. Furthermore, Workgroup and Small business Editions are also being retired.

Currently there are only…

0 comments, 814 reads

Posted in James' SQL Footprint on 5 April 2012

Install SQL Server 2012 Book online on local disk

After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book online document found...........I thought I might not select the local help document during installation, but by researching, it is the new feature of SQL Server 2012..........I don't know what sql…

4 comments, 3,764 reads

Posted in James' SQL Footprint on 1 April 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Archives: April 2012

Generate restore script automatically by backup history table

Setup database mirroring and log shipping together

script system object in resource database

Log shipping setup problem

Why I can not connect sql server ???

Why shrink sql server data file failed?

Clean SQL Server Cache

SQL Server 2012 license

Install SQL Server 2012 Book online on local disk