Welcome to SSC.

If you would be so kind as to follow the second link in my signature on posting code and data for the best help, I am sure some...

Your first error that database already exists, is because you already have a database with that name.

Drop the existing database or change the name of the database in your script.

The...

How are you performing the backups?

Maintenance plan? Script in a job? Manual running of a script?

From the description you have given yes it should only be a blocking issue, so either your not seeing the full picture or something else is happening.

Do you have the...

First error is, a database is already using the logical filename. So I am guessing you already have the database created.

The other error in the ALTER is that you...

Same command, two different servers? I would look at a central management server.

SQL is none load balancable.

But you can get cleaver with transactional replication with updateable subscriptions, peer to peer replication to create a sort of load balanced environment.

What is the bottleneck?...

First off I will jump in and say that shrinking files is an expensive and performance impacting operation, as you will need to rebuild all indexes after shrinking the file.

It...

What is the result of DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS when run in master?

Do you have backups of master which you can restore from?

http://msdn.microsoft.com/en-us/library/ms190679%28v=sql.90%29.aspx

If I understand correctly, you want to look at the CREATE DATABASE command.

When I get a spare moment I will see if I can find anything which may suit.

But in the mean time 6236 will give you the basics, then you can...

Personally, each database has its own file and is timestamped so only 1 file ever exists in a backup set.

Each time you want to do a restore you will need...

If you have two lines in the condition for the facet, one with @insert or @update and the other with @name then it is setup right.

The policy for that type...

Just out of interest what kind of SSRS training do you want?

Administraion/management or SSRS report development?

I personally would day 6236 is more focused on admin/management/maintainability, although it does go into...

License renewal, you mean software assurance?

If you have paid for SA and you upgrade to SQL 2012 then your licenses change to core based licensing, and you get what ever...