Viewing 15 posts - 91 through 105 (of 120 total)
RESTORE DATABASE UK
FROM DISK = '\\SQLSERVER\Backup\Newfull.bak'
WITH REPLACE,
MOVE 'LIST_New' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK.mdf',
MOVE 'LIST_Log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK_log.mdf'
WHEN I AM EXECUTING THIS COMMAND I AM GETTING ERROR
Msg 3234,...
May 24, 2010 at 6:21 am
backup file located at one server disk and backfile mdb located at other server disk..........
thats is not empty string just name purpose only i leaved it blank...
May 24, 2010 at 5:09 am
This Question is Based on Index Structures
Spatial and Filtered indexes have a B-Tree structure.
Full-text indexes have a token-based functional index.
XML Primary indexes have an internal table(aka nodes table)....
May 21, 2010 at 1:10 am
Good Question .....By Seriously I attempted the question luckly my answer is match with answer....
May 19, 2010 at 12:52 am
The CODEPOINT() is a rarely used function in the SSIS expression language, but can be an effective tool in your ETL arsenal in some cases.
April 30, 2010 at 2:51 am
SQL Server 2008 provides Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the...
March 31, 2010 at 12:58 am
In SQL Server 2005, column-level (sometimes called cell-level) encryption became available. Now, encryption could occur within the database, but it was not easy to use, offered poor performance, and it...
March 23, 2010 at 1:15 am
and then from all users try to post questions with wrong answers ..then who was responsible for this kind ...
March 19, 2010 at 3:17 am
The Responsibility is more on the Question Posted by the user....he has full responsible for all this.....
March 19, 2010 at 1:34 am
Normally there are 3 types while performing restoration,
1.Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH ----)
2.Leave...
March 18, 2010 at 12:47 am
YAA STARTED WITH NICE QUESTION AND LEARNED MORE SQL 2008..!
March 17, 2010 at 5:12 am
Nice Question ....Today i learned this from Central...Good Question
March 10, 2010 at 11:19 pm
March 4, 2010 at 2:56 am
Viewing 15 posts - 91 through 105 (of 120 total)