I haven't SQL2012 at my hands right now, so the mentioned steps could be a bit different. So if you can't find it at once, just look a bit around...

Yeah, I know. It can be a pain to get code with single, double, triple, quadriple and sometimes even more quotes. Your solution with the REPLACE is a good appraoch.

1. Take the database OFFLINE

2. copy the LOG file to the new location

3. Change the location in the master database with code:

ALTER DATABASE [dbname] MODIFY FILE (NAME = 'logical_name',...

I suggest you place the tables that are...

You are correct. Keep in mind possible issues regarding IDENTITY columns and/or FOREIGN KEY relations.

But basically you can use "INSERT INTO [target]..table SELECT ... FROM [source]..table" to get the data...

This question looks like homework, so I only give you an overview. That would be enough to solve your question.

Restore, as a new database, the the most recent FULL (and...

When you apply a rownumber (inside the CTE), you can also get the desired rows by using a select TOP with a WHERE:

SELECT TOP (10000)

*

FROM table

WHERE rownumber > @int *10000

ORDER...

Instead of NTILE you could also apply a ROW_NUMBER. Add logic to your query to calculate the required rownumbers depending on your input variable (like: 1 = row 1 -...

I don't know how it performs on such a large dataset, but you can take a look at the NTILE() ranking function. A drawback is that the NTILE cannot be...

It depends on the setup and secification of your environment. Backup to direct attached storage will probably be the fastest solution because you are not bind to the network bandwith....

Have you downloaded and installed the Database Tools?

From the microsoft website:

•Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)

•This package contains everything needed...

double post, please reply to http://www.sqlservercentral.com/Forums/Topic1468772-1292-1.aspx?Update=1

double post, please reply to http://www.sqlservercentral.com/Forums/Topic1468772-1292-1.aspx?Update=1

You can use the -U and -P parameters. Take a look at http://msdn.microsoft.com/en-us/library/ms162802.aspx of the complete syntax.

I don't know if this will be the solution, but I suggest to increase the size of variable @filename to NVARCHAR(165). Because this variable is build upon (adding text to)...