Viewing 11 posts - 46 through 56 (of 56 total)
Backup & restore will be much better option and that to at the time when there is less load on the server.It will be faster during night time.
November 3, 2011 at 9:40 pm
In Mirroring there are 3 modes
1)Asynchronous mode--When you select Asynchronous mode changes 1st commit at principal then transferred to mirror where there is chances of data loss.
2)Synchronous mode(with Automatic Failover)When...
October 31, 2011 at 12:42 am
The account by which SQL Server Agent is running should have the read write permission on the secondary server.
This error generally comes when you do not have read write permission...
October 24, 2011 at 10:10 pm
You can use Import/Export wizard where you need to specify the Source/Destination.Its quite simple to use it.
It can also be transferred using SSIS Package where you need to specify to...
October 23, 2011 at 10:50 pm
The chances are very few that your Full & differential backups sizes will be same.
because differential backup backs up only the changes that have taken place since last...
October 23, 2011 at 10:32 pm
Use this command it will work for you
Restore database Database_name from disk=' ' with
move 'logical name of data file' to ' C:\abc.mdf'
move 'logica name of log file' to...
October 23, 2011 at 10:18 pm
For 90 % record use statement
SELECT TOP 90 PERCENT * from Table name
& for select top 20 rows just use
SELECT TOP 20 * from table name
February 16, 2011 at 4:13 am
In this link
Microsoft SQL Server 2005 Service Pack 4 RTM
--it means that SP4 has 1 more cumulative update which has build 9.00.5254 whereas service pack 4...
February 16, 2011 at 4:04 am
See Ravi RTM stands for RELEASE TO MANUFACTURE & there is nothing called Service pack 4 RTM.
RTM was used prior to Service pack 1
February 16, 2011 at 12:36 am
While creating login that can access a particular database you need to map that database which you want to give access.It can be done by going to User mapping option...
February 16, 2011 at 12:15 am
For 2000 & 2005- SP4
For 2008 -SP2
For 2008R2- RTM (Release to Manufacture)
February 16, 2011 at 12:05 am
Viewing 11 posts - 46 through 56 (of 56 total)