Viewing 15 posts - 5,491 through 5,505 (of 6,395 total)
as long as it doesnt use anything which is in the Differences Between Lower Compatibility Levels and Level 100 section of that article then yes
March 21, 2012 at 9:36 am
the compatiability level only affects certain things like DBCC CHECKDB etc which behave differently between 2000 and 2008
take a look here for the difference which are affected with the compatability...
March 21, 2012 at 9:29 am
as long as the differential backup taken from the primary is in sync with the full backup which initialised the secondary you should be ok. if you have done...
March 21, 2012 at 9:26 am
http://msdn.microsoft.com/en-us/library/bb326318.aspx
Possible Causes
Another database is already using the file name.
Are you sure that the files dont already exist?
How are you doing the restore via T-SQL script or the wizard?
March 21, 2012 at 4:19 am
take a look at the restore database commands in BOL or google it will detail how to use with move and replace etc
the problem is your trying to restore a...
March 21, 2012 at 4:12 am
far to much to detail on a forum, as Koen suggested a Google search will be the best way to go
March 21, 2012 at 4:09 am
its not true load balancing, you can spread out the reads but you cant spread out the writes.
March 21, 2012 at 2:14 am
no, its only a fail over cluster for the database engine, you can load balance SSRS but that is done via stand alone nodes using scaled out deployment, SSRS and...
March 21, 2012 at 1:59 am
the script i provided will also give you the information but for all reports which have subscriptions so your not having to load each report to view its individual subscriptions
March 21, 2012 at 1:55 am
your confusing the physical user with the actual user, its the user which is running the AOT which needs to be sysadmin or DB_Owner not the user sat in the...
March 21, 2012 at 1:54 am
then you dont have a local instance of SQL installed which is why you cannot connect
March 20, 2012 at 10:29 am
SQL SERVER (instancename) where instancename is the name of the instance you want to connect to, if its default is MSSQLSERVER, if its named it will be the name so...
March 20, 2012 at 10:20 am
can look in config manager or services.msc, looking for a state of running or started depending which you look at
March 20, 2012 at 10:10 am
Viewing 15 posts - 5,491 through 5,505 (of 6,395 total)